摘要:
SQL Server 本地时间和UTC时间的相互转换的代码DECLARE @LocalDate DATETIME,@UTCDate DATETIME,@LocalDate2 DATETIMESET @LocalDate = GETDATE()SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate)SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate)SELECT '1. Now 阅读全文