SQL Server 2008 - 如何将GMT（UTC）datetime转换为本地日期时间？ [英] SQL Server 2008 - How to convert GMT(UTC) datetime to local datetime?

问题描述

我有一个insert proc，将 GETDATE（）作为值之一传递，因为每个插入插入时都会存储。这是托管在SQL Azure上，它使用GMT。

现在，当我收到消息时，我们为每个时间戳列存储了GMT日期，如何在访问我的页面时，无论您身在何处，我都将其转换为本地 datetime

谢谢。

解决方案

你可以这样做： / p>

  declare @InputUtcDateTime datetime2 ='2011-05-20 06:30:18'
 
 declare @ LocalDateTime datetime2 = dateadd（minute，datepart（TZoffset，sysdatetimeoffset（）），@InputUtcDateTime）
 print @LocalDateTime 
  

或

  declare @InputUtcDateTime datetime2 ='2011-05-20 06:30:18'
 
 declare @LocalDateTime datetime2 = dateadd（minute，datediff（minute，sysutcdatetime（），sysdatetime（）），@InputUtcDateTime）
 print @LocalDateTime 
  pre> 
I have an insert proc that passes in GETDATE() as one of the values because each insert also stores when it was inserted. This is hosted on SQL Azure - which uses GMT.

Now, when I am receiving messages, I have the GMT date stored for each of them in their timestamp columns, how do I convert this to the local datetime for wherever you are when you are accessing my page? 

Thanks.
解决方案
You could do something like this:
declare @InputUtcDateTime datetime2 = '2011-05-20 06:30:18'

declare @LocalDateTime datetime2 = dateadd(minute, datepart(TZoffset, sysdatetimeoffset()), @InputUtcDateTime)
print @LocalDateTime
or
declare @InputUtcDateTime datetime2 = '2011-05-20 06:30:18'

declare @LocalDateTime datetime2 = dateadd(minute, datediff(minute, sysutcdatetime(), sysdatetime()), @InputUtcDateTime)
print @LocalDateTime


                        
这篇关于SQL Server 2008  - 如何将GMT（UTC）datetime转换为本地日期时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！