跟小D每日学口语
2011年3月14日
UTC datetime values in SQL Server 2000
摘要： You can convert local datetime values to UTC datetime values, and vice-versa, using the built-in GETUTCDATE() function:DECLARE @LocalDate DATETIMESET @LocalDate = GETDATE()-- convert local date to utc dateDECLARE @UTCDate DATETIMESET @UTCDate = DATEADD(Hour, DATEDIFF(Hour, GETUTCDATE(), GETDATE()), 阅读全文
posted @ 2011-03-14 17:00 Danny Chen 阅读(324) 评论(0) 推荐(0)