Re: ROUND to nearest 0.05?
From: Richard Kuhler <noone_at_nowhere.com>
Date: Mon, 12 Jan 2004 22:40:01 GMT
Message-ID: <5nFMb.55587$nG3.32556_at_twister.socal.rr.com>
>>Hey all,
>>
>>For the new year we're updating our price lists to reflect an increase
>>of 1.5%, but... we need to round the prices to the nearest 0.05. Is
>>there a way to do this in SQL*Plus?
>>
>>Basically I want to emulate the MROUND function in Excel (eg.
>>MROUND((cell*1.015), 0.05).
>>
>>Thoughts?
>
Date: Mon, 12 Jan 2004 22:40:01 GMT
Message-ID: <5nFMb.55587$nG3.32556_at_twister.socal.rr.com>
Sean Chang wrote:
> select round( price*1.015*20) /20 from your_table; > > "dbarchitech" <noble_kid_at_mac.com> wrote in message > news:9d3dc423.0401121131.5266739f_at_posting.google.com... >
>>Hey all,
>>
>>For the new year we're updating our price lists to reflect an increase
>>of 1.5%, but... we need to round the prices to the nearest 0.05. Is
>>there a way to do this in SQL*Plus?
>>
>>Basically I want to emulate the MROUND function in Excel (eg.
>>MROUND((cell*1.015), 0.05).
>>
>>Thoughts?
>
Why not just ...
round(price*1.015, 2)
-- Richard KuhlerReceived on Mon Jan 12 2004 - 23:40:01 CET