select t1.cdate,t1.trigger_name from (
SELECT t.trigger_name, TO_CHAR(t.next_fire_time / (1000 * 60 * 60 * 24) +
TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'HH24:MI:SS') AS CDATE
FROM QRTZ_TRIGGERS t) t1
order by t1.cdate
Oracle内毫秒转换为日期
最新推荐文章于 2021-11-30 14:27:25 发布