OraFAQ Forum: SQL & PL/SQL » converting number of seconds to date and time

Home » SQL & PL/SQL » SQL & PL/SQL » converting number of seconds to date and time

Sat, 17 January 2004 21:55

Tudobat
Messages: 1
Registered: January 2004

Junior Member

Hello,

How could I convert the number of seconds since 01/01/1970 to the date and time?

Any help is greaty appreciated,

T.

Sun, 18 January 2004 01:50

Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA

Senior Member

SELECT TO_DATE ('01/01/1970', 'MM/DD/YYYY')
+ (&seconds_since_jan_1_1970 / (60 * 60 * 24))
FROM DUAL
/

Previous Topic:	ora-00918 column ambiguously defined
Next Topic:	Blocking stored procedure

Goto Forum:

]

Current Time: Fri Apr 26 19:36:20 CDT 2024