导航

UTC or GMT time in SQL Server 2005/2008

Posted on 2010-02-20 13:41  AlexCube  阅读(402)  评论(0)  编辑  收藏  举报

SQL Server 中获取GMT时间：

SELECT GETDATE() - 2009-03-28 13:08:37.553

SELECT SYSDATETIME() - 2009-03-28 13:08:37.5570000

SELECT GETUTCDATE() - 2009-03-28 07:38:37.557

SELECT SYSUTCDATETIME() - 2009-03-28 07:38:37.5570000

SELECT SYSDATETIMEOFFSET() - 2009-03-28 13:08:37.5570000 +05:30

 

 

To find a difference between the Local time and UTC time use this query:

SELECT DATEDIFF(MINUTE,GetDate(),GetUTCDate());

 

Note: You may also want to checkout the SYSUTCDATETIME SWITCHOFFSET and TODATETIMEOFFSET functions