Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Converting a Number to a Date
select to_char(to_Date('01011970', 'mmddyyyy') + (960770731/86400),
'MM-DD-YYYY HH24:MI:SS')
from dual
SQL> /
TO_CHAR(TO_DATE('01
HTH
Raj
![]() |
![]() |