Why does SQL Server round off results of dividing two integers?
When you do integer division (integer divided by integer) you always get an integer answer. 50/100 = .50, which is 0 in integer-speak. Have you tried dividing MY_COLUMN by 100.0?
rounding
How to ceil, floor and round bcmath numbers?
After a night lost trying to solve this problem I believe I’ve found a rather simple solution, here it is: function bcceil($number) { if (strpos($number, ‘.’) !== false) { if (preg_match(“~\.[0]+$~”, $number)) { return bcround($number, 0); } if ($number[0] != ‘-‘) { return bcadd($number, 1, 0); } return bcsub($number, 0, 0); } return $number; } … Read more
Rounding to nearest fraction (half, quarter, etc.)
Since you’re looking for fourths (.00, .25, .50, .75), multiply your number by 4, round to nearest whole number as desired (floor if down, ceil if up), then divide by 4. 1.32, down to nearest fourth: 1.32 * 4 = 5.28 floor(5.28) = 5.00 5.00 / 4 = 1.25 Same principle applies for any other … Read more
Rounding a number to the nearest 5 or 10 or X
It’s simple math. Given a number X and a rounding factor N, the formula would be: round(X / N)*N
Round a divided number in Bash
To do rounding up in truncating arithmetic, simply add (denom-1) to the numerator. Example, rounding down: N/2 M/5 K/16 Example, rounding up: (N+1)/2 (M+4)/5 (K+15)/16 To do round-to-nearest, add (denom/2) to the numerator (halves will round up): (N+1)/2 (M+2)/5 (K+8)/16
Discard millisecond part from timestamp
A cast to timestamp(0) or timestamptz(0) rounds to full seconds: SELECT now()::timestamp(0); Fractions are not stored in table columns of this type. date_trunc() truncates (leaves seconds unchanged) – which is often what you really want: SELECT date_trunc(‘second’, now()::timestamp);
Rounding numbers to 2 digits after comma
EDIT 2: Use the Number object’s toFixed method like this: var num = Number(0.005) // The Number() only visualizes the type and is not needed var roundedString = num.toFixed(2); var rounded = Number(roundedString); // toFixed() returns a string (often suitable for printing already) It rounds 42.0054321 to 42.01 It rounds 0.005 to 0.01 It rounds … Read more
Javascript: Round up to the next multiple of 5
This will do the work: function round5(x) { return Math.ceil(x/5)*5; } It’s just a variation of the common rounding number to nearest multiple of x function Math.round(number/x)*x, but using .ceil instead of .round makes it always round up instead of down/up according to mathematical rules.
How to Round a Time in T-SQL
Try this function CREATE FUNCTION [dbo].[RoundTime] (@Time datetime, @RoundTo float) RETURNS datetime AS BEGIN DECLARE @RoundedTime smalldatetime DECLARE @Multiplier float SET @Multiplier= 24.0/@RoundTo SET @RoundedTime= ROUND(CAST(CAST(CONVERT(varchar,@Time,121) AS datetime) AS float) * @Multiplier,0)/@Multiplier RETURN @RoundedTime END select dbo.roundtime(’13:15′,0.5) The 1st param is the time to be rounded and the 2nd will be base on your list … Read more
What’s the disadvantage of mt_rand?
mt_rand uses the Mersenne Twister algorithm, which is far better than the LCG typically used by rand. For example, the period of an LCG is a measly 232, whereas the period of mt_rand is 219937 − 1. Also, all the values generated by an LCG will lie on lines or planes when plotted into a … Read more