数据库格式:
数据库mysql语句:
FROM_UNIXTIME(
s.timemodified,
'%Y-%m-%d %h:%i:%s'
)
生成结果:
测试sql为:
SELECT
*,
FROM_UNIXTIME(
timemodified / 1000,
'%Y-%m-%d %h:%i:%s'
)
FROM
scorm
ORDER BY id DESC
2022-11-12 19:06:37
数据库格式:
数据库mysql语句:
FROM_UNIXTIME(
s.timemodified,
'%Y-%m-%d %h:%i:%s'
)
生成结果:
测试sql为:
SELECT
*,
FROM_UNIXTIME(
timemodified / 1000,
'%Y-%m-%d %h:%i:%s'
)
FROM
scorm
ORDER BY id DESC