Azure Database : Wrong Time Zone

Where on Azure can I set my time zone right ? My datetime trigger as a result does not give me local time right. I am 2 hours backwards.


https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/07/27/lesson-learned-4-modifying-the-default-time-zone-for-your-local-time-zone/

Currently, the default time zone on Azure SQL DB is UTC. Unfortunately, there is not possible to change by server configuration or database configuration.


It appears that you can now set the timezone upon creation but there is not an option to change it after that.

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-timezone

This is still in public preview though: https://azure.microsoft.com/en-us/updates/managed-instance-time-zone-preview/


You need to set the WEBSITE_TIME_ZONE app setting. Please refer to the following link: https://github.com/projectkudu/kudu/wiki/Configurable-settings#set-the-time-zone


Azure SQL databases are set to UTC timezone with no option to change them.