We are excited to announce the public preview of local time zone support in Azure SQL Database. You can now configure a time zone at the database level and override it for an individual session using T-SQL. This functionality allows applications to use current date and time values in their local time zone without adding an explicit conversion to every call.
Local time zone support simplifies migration of applications that rely on SQL Server's local time and supports databases serving different geographic regions. Azure SQL Database continues to use UTC by default. You choose whether to configure a database-wide time zone or apply a session-specific setting.
For more details on the functionality, see the feature announcement in the Azure SQL Dev corner.
Microsoft