摘要: 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&# 阅读全文
posted @ 2011-02-22 17:33 KymoWang 阅读(6606) 评论(0) 推荐(0) 编辑