Select to_char(to_date(’01-JAN-1970′) + 1257424753/86400,’DD-MM-YYYY HH:MI:SS’) from dual;
SELECT to_char(TO_DATE(’19700101000000′,’YYYYMMDDHH24MISS’)
+ NUMTODSINTERVAL(1257424753, ‘SECOND’),’DD_MM_YY HH24:MI:SS’) FROM DUAL
|
||||||
oracle timestampSelect to_char(to_date(’01-JAN-1970′) + 1257424753/86400,’DD-MM-YYYY HH:MI:SS’) from dual; SELECT to_char(TO_DATE(’19700101000000′,’YYYYMMDDHH24MISS’) |
||||||
|
Copyright © 2010 El-Shihabi - All Rights Reserved |
||||||