November 19, 2024 at 4:47 am
Hello Everyone,
I am using Microsoft SQL Azure (RTM) - 12.0.2000.8, as of October 2, 2024. This software is copyrighted by Microsoft Corporation in 2022.
We have developed a ticketing system currently used by around 30 countries, and we expect this number to grow in the coming days.
To maintain each country's local time, we have collected their respective time zones. Initially, everything worked fine. However, as time passed, some countries requested changes to their time zones due to Daylight Saving Time (DST).
When we manually change a country's time zone, it affects the local time of tickets that have already been created. Since this is a newly developed module, we can manage these changes manually for now. However, in the future, we would like the system to automatically adjust the time zones for countries that observe different time zones at different times of the year.
Is there a method or workaround to manage this situation efficiently?
Kindly guide me.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply