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