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版权声明：本文为u010758605原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。