top.insert_time是精确到秒的数据:
select TO_CHAR(top.insert_time / ( 60 * 60 * 24) +
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS CDATE from talbeName
oracle将unix时间戳格式转成日期格式显示
最新推荐文章于 2024-04-18 15:57:18 发布
top.insert_time是精确到秒的数据:
select TO_CHAR(top.insert_time / ( 60 * 60 * 24) +
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH24:MI:SS') AS CDATE from talbeName