SELECT to_date('01-01-1970','DD-MM-') + no_of_seconds / (24*60*60) from
dual;
Regards
Naveen
-Original Message-
Sent: Thursday, January 23, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Hi all
One of the developers came to me. They are using a Genesys call logging
system.
I
>
>Hi all
>
>One of the developers came to me. They are using a
>Genesys call logging
>system.
>
>It has apparently stored a date time in a number
>field as the number of
>seconds since 1970 1 Jan 0:00
>
>They need to know exactly what time this is.
>
>I can not off hand remember that oracle got a