Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Should've asked the reverse -- DATE to milliseconds
select 864000000*(:mydate - to_date('19700101','yyyymmdd') from dual;
Note that DATEs do not store milliseconds.
Hth,
Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm)
http://www.dynamicpsp.com
Received on Mon May 22 2006 - 09:18:29 CDT