AT TIME ZONE targeting Microsoft Azure SQL Database V12

rerezzrerezz Posts: 5
edited March 10, 2017 4:24AM in ReadyRoll
I can't build the project with my function using TIMEZONE on target platform Microsoft Azure SQL Database V12 (It does with target Sql Server 2016). Visual Studio database project with the same function builds successfully for target platform Microsoft Azure SQL Database V12.

Code in the function: 
DECLARE @nowServer DATETIMEOFFSET = SYSDATETIMEOFFSET()
DECLARE @nowCET DATETIMEOFFSET = CONVERT(DATETIMEOFFSET, @nowServer) AT TIME ZONE 'W. Europe Standard Time'

RETURN CONVERT(DATETIME, @nowCET)
· Share on Twitter

Comments

Sign In or Register to comment.