ROUND to nearest 0.05?

[dbarchitech]

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?

[Sean Chang]

select round( price*1.015*20) /20 from your_table;

"dbarchitech" <noble_kid@mac.com> wrote in message
news:9d3dc423.0401121131.5266739f@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?




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

[Dave]

Sean Chang wrote:
select round( price*1.015*20) /20 from your_table; "dbarchitech" <noble_kid@mac.com> wrote in message news:9d3dc423.0401121131.5266739f@posting.google.com...Hey all,For the new year we're updating our price lists to reflect an increaseof 1.5%, but... we need to round the prices to the nearest 0.05. Isthere 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 Kuhler

[Dave]

Richard Kuhler wrote:
Sean Chang wrote: select round( price*1.015*20) /20 from your_table; "dbarchitech" <noble_kid@mac.com> wrote in message news:9d3dc423.0401121131.5266739f@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)

Doh! Nevermind, I read the post too fast. Obviously the solution I
posted is wrong. You will have to perform the round as Sean already
correctly pointed out.

--
Richard Kuhler