直接使用那个日期加上对应的天数, 也就是你的秒数除以86400就可以了^_^
[code]
SQL> select sysdate , (sysdate - to_date('19700101080000','yyyymmddhh24miss')) * 86400 seconds
2 from dual
3 /
SYSDATE SECONDS
--------- ----------
18-JAN-05 1106037442
SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';
Session altered.
SQL> select sysdate , (sysdate - to_date('19700101080000','yyyymmddhh24miss')) * 86400 seconds
2 from dual
3 /
SYSDATE SECONDS
------------------- ----------
2005-01-18 16:37:53 1106037473
SQL> select to_date('19700101080000','yyyymmddhh24miss') + 1106037473 / 86400 cur_date
2 from dual
3 /
CUR_DATE
-------------------
2005-01-18 16:37:53
SQL> select to_date('19700101080000','yyyymmddhh24miss') + 1106037900 / 86400 cur_date
2 from dual
3 /
CUR_DATE
-------------------
2005-01-18 16:45:00
SQL>
[/code]
将数据库里面的时间从1970年1月1日8:00开始的秒数转换成日期格式
最新推荐文章于 2024-04-29 02:42:06 发布