Re: Rounding Up

A copy of this was sent to "Ben Ralph" <ben_at_ralph.demon.co.uk> (if that email address didn't require changing) On Sun, 27 Jun 1999 12:43:05 +0100, you wrote:

>How do I round up values in Oracle? I want 1.0024 to become 2.
>
>TIA
>Ben
>

SQL> select ceil( 1.0024 ) from dual;

CEIL(1.0024)

           2

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Sun Jun 27 1999 - 08:59:31 CDT