SQL Server本地时间和UTC时间的相互转换实现代码
摘要:
View Code DECLARE @LocalDate DATETIME, @UTCDate DATETIME, @LocalDate2 DATETIME SET @LocalDate = GETDATE() SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate) SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate) SELECT '1. Now' [Now], @L 阅读全文
posted @ 2013-04-18 18:20 pass 阅读(120) 评论(0) 推荐(0) 编辑