Re: simple SQL question about dividing numbers

From: Julian Kooiker <julian.kooiker_at_quicknet.nl>
Date: Tue, 19 Feb 2002 07:27:30 GMT
Message-ID: <C7nc8.90482$yS6.7051251@amsnews02.chello.com>

thank you. Do you know what the function 'floor' does? It looks like the same as trunc then. "DStevens" <dstevens_at_navidec.com> schreef in bericht news:a4s0f6$otv$1_at_newsreader.mailgate.org... 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 Tue Feb 19 2002 - 01:27:30 CST