DateTime and TimeZone setting on existing Azure VM

Question

User-733996868 posted

We have an Azure VM with Sql server. Currently, machine Time zone is Coordinated Universal Time and date format is mm/dd/YYYY.  I want to change Time Zone of system to Dublin, Edinburgh, Lisbon, London with automatic daylight saving 

We have 10 huge databases on a machine with huge data. if i change the time zone and date format to dd/mm/YYYY does this affect on existing DB values ?

Answer 1

User-271186128 posted

Hi Narasappa C J,

We have 10 huge databases on a machine with huge data. if i change the time zone and date format to dd/mm/YYYY does this affect on existing DB values ?

I suppose it will not affect the existed DB value, but after changing, it might affect the new insert values. It depends on how do you insert the date into the database.

Since the existed DB values using UTC time, I suggest before inserting the new time into the database, you should convert the time to UTC time. After that, if you want to display the time, you could convert the time to local time and use DateTime.ToString method to set the Date Format.

Best regards,
Dillion