时间与时间戳转换

SELECT DATEADD(s, 1369120631, '1970-01-01 00:00:00')
SELECT DATEDIFF(s, '19700101','2013-05-21 07:17:11')

原文地址:https://www.cnblogs.com/jiangdd/p/3092683.html