|
erics, July 11th, 2013 select theField from theTable order by theField+0; ~OR~ select theField from theTable order by CAST(theField AS UNSIGNED);
Categories: How-To's, Technology 0, Add, Cast, howto, Number, sort, String, text(), tips, Zero
| 
No comments
erics, September 23rd, 2012 |
1 2 3 4 5 |
var num = 10; var result = num.toFixed(2); // result will equal 10.00 var num= 170.2305; var result = num.toFixed(3); // result will equal 170.231 |
Categories: How-To's, Technology Decimal, Format, Format Number, howto, javascript, JS, Number, Number Format, Places, Round, Rounding, tips, toFixed
| No comments
erics, December 1st, 2011 PHP number_format($number, 2, ‘.’, ‘,’); SMARTY {$number|number_format:2:”.”:”,”}
Categories: How-To's, Technology Format, howto, Number, php, Smarty, tips
| No comments
erics, October 28th, 2011 This solution is hyper-simplistic, and does not deal with decimals or real numbers (those with either a – or a + in front of them)…
|
1 2 3 4 5 |
if ($value =~ /^\d+$/) { ## $value is an integer } else { ## $value is NOT an integer } |
Categories: How-To's, Technology howto, Integer, Number, Numeric, perl, tips
| No comments
erics, October 10th, 2011 |
1 2 |
my $number = 123.45; printf("%.3f", $number); |
Outputs: 123.450
Categories: How-To's, Technology Decimal, Float, Floating, Floating Point, Format, howto, Number, perl, printf, Round, Rounding, sprintf, tips
| No comments
erics, October 10th, 2011 To round up to the nearest 5:
|
1 2 |
use Math::Round qw(nhimult); $roundedUpNumber = nhimult( 5, $originalNumber ); |
http://search.cpan.org/dist/Math-Round/Round.pm To round up to the nearest 1: Cross-posted from PerlMonks:
|
1 2 3 4 |
sub roundUp { my $n = shift; return( $n == int($n) ? $n : int($n + 1) ); } |
Categories: How-To's, Technology Format, howto, Number, perl, Round, Rounding, tips
| No comments
