FROM_UNIXTIME(激活时间毫秒数
/1000,’%Y-%m-%d %H:%i:%s’)
示例:
SELECT trigger_last_time,FROM_UNIXTIME(trigger_last_time/1000,'%Y-%m-%d %H:%i:%s') AS last_time
FROM xxl_job_info
WHERE job_cron LIKE '%23%';
FROM_UNIXTIME(激活时间毫秒数
/1000,’%Y-%m-%d %H:%i:%s’)
示例:
SELECT trigger_last_time,FROM_UNIXTIME(trigger_last_time/1000,'%Y-%m-%d %H:%i:%s') AS last_time
FROM xxl_job_info
WHERE job_cron LIKE '%23%';