ianal Vista wrote:
> laredotornado@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