Re: getting milliseconds from a DATE

From: Robert Klemme <bob.news_at_gmx.net>
Date: Mon, 08 May 2006 17:31:32 +0200
Message-ID: <4c96ikF14fn7kU2@individual.net>

ianal Vista wrote:

> 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

Hey, you could have been more helpful. Why didn't you suggest to convert the DATE to TIMESTAMP and then extract ms?

SCNR         robert Received on Mon May 08 2006 - 10:31:32 CDT