SqlServer 把Long类型日期还原yyyy-MM-dd 00:00:00格式日期
做个记录:
select CONVERT(DATETIME, Dateadd(second, 1620437293459 / 1000, '19700101 08:00'), 111) AS startTime
做个记录:
select CONVERT(DATETIME, Dateadd(second, 1620437293459 / 1000, '19700101 08:00'), 111) AS startTime