AT TIME ZONE targeting Microsoft Azure SQL Database V12

rerezz

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)

dnlnln

We have confirmed this to be a bug in the current version of ReadyRoll (1.13.21). It affects projects that target either of the Microsoft Azure SQL Database/V12 platforms. Please try this build and let me know if it resolves the issue for you:
http://download.ready-roll.com/ReadyRol ... 1.2918.exe