ROUND to nearest 0.05?
From: dbarchitech <noble_kid_at_mac.com>
Date: 12 Jan 2004 11:31:53 -0800
Message-ID: <9d3dc423.0401121131.5266739f_at_posting.google.com>
[Quoted] Hey all,
Date: 12 Jan 2004 11:31:53 -0800
Message-ID: <9d3dc423.0401121131.5266739f_at_posting.google.com>
[Quoted] Hey all,
[Quoted] 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? Received on Mon Jan 12 2004 - 20:31:53 CET