Select CONVERT(varchar(100), DATEADD (MS ,1642581564742 % 60000 ,DATEADD(MI,1642581564742 / 60000,'1970-01-01 08:00:00')), 23)
Sql server 13位时间戳转换日期格式
最新推荐文章于 2024-07-31 15:15:01 发布
Select CONVERT(varchar(100), DATEADD (MS ,1642581564742 % 60000 ,DATEADD(MI,1642581564742 / 60000,'1970-01-01 08:00:00')), 23)