我会说将其声明为变量并从datetimeoffset
Convert那里获取日期时间信息datetime
就可以了
DECLARE @MyUtctime DATETIMEOFFSET
SET @MyUtctime = (
SELECT getdate() AT TIME ZONE 'EASTERN standard time' at TIME zone 'UTC'
)
SELECT CONVERT(DATETIME, @MyUtctime, 1)
SELECT getdate()