- 13位字符串:1638413459000
- 日期:2021-12-02 10:50:59
- 语法:
select FROM_UNIXTIME(1638413459000/1000,"%Y-%m-%d %H:%i:%s") as Time
- 如果10位时间戳则不需要除1000,语法:
select FROM_UNIXTIME(1638508575,"%Y-%m-%d %H:%i:%s") as Time
select FROM_UNIXTIME(1638413459000/1000,"%Y-%m-%d %H:%i:%s") as Time
select FROM_UNIXTIME(1638508575,"%Y-%m-%d %H:%i:%s") as Time