Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TRUNC equivalent to return the decimal part?

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@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 - 08:16:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US