Click to See Complete Forum and Search --> : round to nearest 0 or 5


zulu99
09-24-2003, 09:55 AM
Hi

I want an sql query something like this
which will round say

200.23 to 200.20
and 200.26 to 200.25

How to get this

Rgrds

DaPi
09-24-2003, 10:15 AM
select trunc(200.23*2,1)/2 from dual