Re: converting date to milliseconds?

laredotornado_at_zipmail.com wrote:
> 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

The best way would be to upgrade to a version of the Oracle database that is supported in the current millenium.

Not only does the functionality exist ... it will greatly improve your resume.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)