Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

convert seconds to date

564278Apr 3 2007 — edited Apr 3 2007
I was working on this query but I was wondering if there was a way to convert seconds to a date. The program records the number of seconds since January 1, 1960.
SELECT (CLINICALDATE/1000000) "DATE" FROM DOCUMENT WHERE ROWNUM < 6
DATE                   
---------------------- 
1389799659             
1406552001             
1406553986             
1406553986             
1406555279             

5 rows selected
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 1 2007
Added on Apr 3 2007
2 comments
4,971 views