Re: ROUND to nearest 0.05?
From: Sean Chang <sean_at_cnfei.com>
Date: Mon, 12 Jan 2004 15:40:18 -0500
Message-ID: <40030632$1_3_at_corp.newsgroups.com>
Date: Mon, 12 Jan 2004 15:40:18 -0500
Message-ID: <40030632$1_3_at_corp.newsgroups.com>
[Quoted] 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?
-----= 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! =----- Received on Mon Jan 12 2004 - 21:40:18 CET