--时间转换为时间戳(毫秒)
DECLARE @ADATE DATETIME
--修改时区偏移量
SET @ADATE = SWITCHOFFSET ('2019-12-01 00:00:00.000', '-08:00')
--SELECT CONVERT(BIGINT,DATEDIFF(MI,'1970-01-01 00:00:00', @ADATE)) * 60000 + DATEPART(S,@ADATE) * 1000 + DATEPART(MS, @ADATE)
SELECT CONVERT(BIGINT,DATEDIFF(s,'1970-01-01 00:00:00.000', @ADATE)) * 1000 + DATEPART(MS, @ADATE)
--时间戳转换为时间(毫秒)+8个时区
DECLARE @UNIXTIME BIGINT
SET @UNIXTIME = 1575129600000
SELECT DATEADD (MS,@UNIXTIME % 60000,DATEADD(MI,@UNIXTIME / 60000,'1970-01-01 08:00:00.000'))