// AZURE SQL USES GREENWICH MEAN TIME . . . Azure SQL Database does not support time zone settings; it always follows UTC. Use AT TIME ZONE in SQ...

[Read the rest of this article...]

UTC

Declare @todays_date Date set @todays_date = CAST(SYSDATETIMEOFFSET() AT TIME ZONE 'Eastern Standard Time' AS date) For example, if you want ...

[Read the rest of this article...]

Azure SQL GetDate()