Azure VM时区和区域设置中的SQL Server [英] SQL Server in Azure VM TimeZone and Regional Settings

问题描述

I have a Windows VM with SQL Server installed on, during the setup I used the standard VM template. Now the System Time zone is UTC, and the SQL Server Getdate() function return UTC time, and DateFormat is mm-dd-yyy instead of dd-mm-yyy.

在服务器上已安装 3D派对 使用GetDate()的应用程序，我们无法更改其代码.

On the server are installed 3d party applications that use the GetDate() and we are unable to change their code.

有没有办法永久更改系统区域设置?

Ruggiero Lauria
MCT-MCITP-MCSA-MCSE-MS SQL DBA

Ruggiero Lauria
MCT-MCITP-MCSA-MCSE-MS SQL DBA

推荐答案

你好，

Hello,

You can change the time zone using PowerShell:

https://social.technet.microsoft.com/wiki/contents/articles/29554.change-time-zone-of-azure-role -instances-vm-s.aspx

https://social.technet.microsoft.com/wiki/contents/articles/29554.change-time-zone-of-azure-role-instances-vm-s.aspx

Hope this helps.

Regards,

SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于Azure VM时区和区域设置中的SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！