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: getting milliseconds from a DATE

Re: getting milliseconds from a DATE

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Mon, 08 May 2006 14:00:07 GMT
Message-ID: <Xns97BD473BDEC6Cianalvistahotmailcom@70.169.32.36> 





laredotornado_at_zipmail.com wrote in news:1147093983.362115.82810
@y43g2000cwc.googlegroups.com:



> Hello,

> 

> I'm using Oracle 9i on Solaris.  How do I take a column of a DATE type

> and convert it to milliseconds that have elapsed since Jan. 1, 1970, 12

> AM?

> 

> Thanks for any help, - Dave

> 

> 




You do NOT get millisecond from DATE; must use TIMESTAMP
Received on Mon May 08 2006 - 09:00:07 CDT












Original text of this message













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