Re: TRUNC equivalent to return the decimal part?
From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Thu, 10 Apr 2003 07:39:50 +0200
Message-ID: <1049952955.163094_at_news.thyssen.com>
Date: Thu, 10 Apr 2003 07:39:50 +0200
Message-ID: <1049952955.163094_at_news.thyssen.com>
"funkia" <yian_at_die.net> wrote...
(snipped)
> conversion on the decimal part of the number. Is there any function
> in SQL that is like TRUNC that returns just the decimal portion?
>
> e.g., if my number is 36.675, I want a function that will return just
> .675 (with or without the period)
Hi 'funkia',
[Quoted] [Quoted] another option, try: select mod(36.675,1) from dual;
hth,
Guido
Received on Thu Apr 10 2003 - 07:39:50 CEST