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