Re: simple SQL question about dividing numbers

Trunc

select 16/5, trunc(16/5) from dual;

      16/5 TRUNC(16/5)
---------- -----------

       3.2 3

Elapsed: 00:00:00.01
SQL> Julian Kooiker wrote:

> Hi,
>
> I have a little problem and I can't find it in the documentation of sql. (I
> have a small learning book).
> If I divide a number, for example 16 / 5 then I want to grab only the number
> before the comma. Which function do I need to use?
>
> Julian Kooiker
Received on Mon Feb 18 2002 - 16:50:22 CST