Blog Post

Azure Database Support Blog
1 MIN READ

Lesson Learned #4: Modifying the default time zone for your local time zone.

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Mar 14, 2019
First published on MSDN on Jul 27, 2016 Currently, the default time zone on Azure SQL DB is UTC . Unfortunately, there is not possible to change ...
Updated Mar 14, 2019
Version 2.0
at time zone
default time zone
getdate
local time zone
sys time_zone_info
utc
Michael Bourgon's avatar
Michael Bourgon
Brass Contributor
Jun 30, 2022

Interesting way around it, but running it through a function could cause performance issues, as shown by Jonathon Kehayias elsewhere. It's frustrating.