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>


"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

Original text of this message