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 -> converting date to milliseconds?

converting date to milliseconds?

From: <laredotornado_at_zipmail.com>
Date: 31 Mar 2005 13:11:06 -0800
Message-ID: <1112303466.399850.177620@g14g2000cwa.googlegroups.com>


Hello, I'm using Oracle 8.1.7 on Solaris. How would I write a select statement to convert a table column of the DATE type to something that's a NUMBER, preferrably with units of seconds or milliseconds?

Thanks, - Dave Received on Thu Mar 31 2005 - 15:11:06 CST

Original text of this message

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