Menu
Can you please tell me how to change the time zone in Azure SQL Database?
856
Changing the database timezone SQL Server users typically fetch the local timezone by using the GETDATE() function with insert/update statements or as a default constraint for a datetime column in a select statement.
To do this, add an application setting (using the portal) called “WEBSITE_TIME_ZONE” equal to the name of the time zone in question (basically the same string as the key name at HKLM\Software\Microsoft\Windows Nt\CurrentVersion\Time Zones\). The list of time zone values is here.
In the Azure portal, search for resource mover. Then, under Services, select Azure Resource Mover. In Overview, click Get started. In Move resources > Source + destination, select the source subscription and region.
While you can't change the default time zone, Microsoft has provided mechanisms for dealing with time zones in your code within Azure. Read this article.
200
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
