SQL Server本地时间和UTC时间的相互转换实现代码
发布时间:2021-12-24 09:13 所属栏目:116 来源:互联网
导读:复制代码 代码如下: 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
复制代码 代码如下: 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], @LocalDate [DateTime] UNION SELECT '2. UTC', @UTCDate UNION SELECT '3. Now again', @LocalDate2 (编辑:ASP站长网) |
相关内容
网友评论
推荐文章
热点阅读