GETUTCDATE（）和时区（SQL Server） [英] GETUTCDATE() and Time Zone (SQL Server)

问题描述

我想在SQL Server中使用功能GETUTCDATE（）添加我的时区。我搜索了几次，但是没有找到任何相关的解决方案。

I want to add my time zone with the function GETUTCDATE() in SQL Server. I searched several times, but did not found any relevant solution. Thanks in advance.

推荐答案

仅适用于sql 2016

only for sql 2016, it takes into account daylight savings.

CREATE FUNCTION GetBelgiumTime 
(
)
RETURNS datetime2
AS BEGIN  
       declare @dateoffset datetimeoffset
       SET  @dateoffset = convert(VARCHAR(2000),(SELECT GETUTCDATE() AT TIME ZONE  'Central European Standard Time'),126 )


       declare @date datetime2
       set @date = convert(datetime2, LEFT(@dateoffset,28),126)

    set @date = DATEADD(HOUR, convert(int,LEFT(RIGHT(@dateoffset,5), 2)), @date) 
       RETURN @date
END

select  dbo.GetBelgiumTime() as BelgiumDateAndTime 

这篇关于GETUTCDATE（）和时区（SQL Server）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！