I am looking for a way to round the decimal portion of numbers up or down to the nearest .25, .5, .75, or whole number

Question

If the decimal part is 0.1 to 0.12, it rounds down to the next lower integer If the decimal part is 0.13 to 0.37 it rounds to 0.25 If the decimal part is 0.38 to 0.62 it rounds to 0.5 If the decimal part is 0.63 to 0.87 it rounds to 0.75 If the decimal part is 0.88 or more, it rounds up to the next higher integer

Answer 1

I don't know the exact function name, but basically you use floor(4*x)/4. floor might be called int, to_int, or something like that.

Answer 2

There is a general method for this:

• Multiply your number by 4.
• Round to the nearest integer.
• Divide by 4.

In SQL:

ROUND(column * 4) / 4

Answer 3

Multiply by 4, round to the nearest integer, divide by 4?