Re: TRUNC equivalent to return the decimal part?

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 11 Apr 2003 06:16:34 -0700
Message-ID: <1a8fec49.0304110516.4dcf732c_at_posting.google.com>


It might work perfectly, but some simple timings show that the subtraction method is far more efficient than MOD.

yian_at_die.net (funkia) wrote in message news:<550d192c.0304100733.18673844_at_posting.google.com>...
> > another option, try: select mod(36.675,1) from dual;
>
> guido - that's perfect, thanks!
Received on Fri Apr 11 2003 - 15:16:34 CEST

Original text of this message