Re: Converting Numbers to Dates

date_value := TO_DATE('01-JAN-70') + (seconds/86400);

I assume when you say 1970, you mean Jan 01. 86400 is the number of seconds in a day.

Andy Smith wrote:
>
> --
> I have a column in a table that stores the number of seconds
> since 1970, as a number ( datatype NUMBER )
>
> How can I convert this to a date e.g 11-MAR-1997
>

(trimmed)

-- 
Joe Rogers
Intelligent Information Systems, Inc.
joer_at_renewal-iis.com