一、MySql 13位时间戳处理
FROM_UNIXTIME
TIMESTAMPDIFF
with t1 as (
SELECT
create_time as "原始时间戳",
FROM_UNIXTIME(create_time /1000) as "时间戳转正常时间格式",
FROM_UNIXTIME( create_time / 1000, '%Y-%m-%d' ) as "提取日期",
FROM_UNIXTIME(create_time /1000, '%H') as "提取小时",
lag(create_time,1) over ( ) as "原始时间戳向下偏移一行"
FROM
table)