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: Should've asked the reverse -- DATE to milliseconds

Re: Should've asked the reverse -- DATE to milliseconds

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 22 May 2006 07:22:17 -0700
Message-ID: <1148307737.604311.176340@i40g2000cwc.googlegroups.com> 





Oops, there's one extra zero in the constant, should read



select 86400000*(:mydate - to_date('19700101','yyyymmdd') from dual;



Hth,


    Vladimir M. Zakharychev


    N-Networks, makers of Dynamic PSP(tm)
    http://www.dynamicpsp.com
Received on Mon May 22 2006 - 09:22:17 CDT












Original text of this message













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