Smit Shah

Scale your apps for multiple time zone

The world would be a better place if every app was built using UTC timezone from day 1.
Unfortunately that is rarely the case.

In this example the company is in the Eastern time zone (EST) and is expanding their operations to be in multiple timezones.

Since the legacy data is in EST format, a major overhaul of the system to use UTC may seem impractical.

In this case, the simplest approach is to make the app use a custom function that returns the adjusted time. In this case, it always returns the EST.

This could also be expanded further to change the time based on the corrosponding visitor.

Below is the video

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet/ BOL /Other sites that are authorities in their field. Me or employer do not endorse any tools, applications, books, or concepts mentioned on the site. I have documented my personal experience on this site. The information on this site may not be up to date or accurate at times, if you are not sure or have a question, please contact me to verify information.