很简单: SELECT DATEADD(second, 1418825907, CAST('1970-01-01 00:00:00' AS datetime)) 转载于:https://www.cnblogs.com/ywkpl/p/4172013.html