Re: TRUNC equivalent to return the decimal part?

"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',

another option, try: select mod(36.675,1) from dual;

hth,
Guido Received on Thu Apr 10 2003 - 00:39:50 CDT