In your persistence medium, database or otherwise, convert all times to UTC before storing them, store all times as UTC, and convert on-the-fly to the user’s local time zone when displaying. In order to convert accurately, use the location style time zones such as “America/Chicago” or “Australia/Sydney”.
As a developer, time is hugely important. If your users span more than one time zone and you display times to them, you have to determine how to handle the fact that 5:00 PM for one user is 6:00 PM for another user.
This could be as simple as stating on-screen that all times are displayed in Central Time or whatever. Not very complicated coding-wise and it might work for you but it gets very confusing for any user not in your target time zone.
Once you are ready to start support the displaying of local times in your application, you have to understand what local times are and how to compute them. It is also recommended that you store all times as UTC.
Coordinated Universal Time
Formerly known as Greenwich Mean Time, Coordinated Universal Time or UTC is the standard for time world-wide. Also sometimes referred to as Zulu time, this is the time that all other timezones refer to. For example, Central Standard Time in North America is UTC time minus 6 hours.
What is a time zone?
You have probably have seen time written as “3/3/2003 3:45 PM CST”. This is probably a fine notation for your area but doesn’t mean a lot for defining a unique time world-wide. The abbreviation “CST” denotes Central Standard Time for North America, Central Standard time for Australia, China Standard Time, or Cuba Standard Time.
In addition, to accurately determine the time for an area, we need to know the offset(s) from UTC time and if and when the area switches to and from daylight savings time.
In the 80s, Arthur David Olson created a database to track the time zone offsets, daylight savings time changes, etc and cover both the current and historical state for those changeovers. This database is sometimes known as the Olson database and the format for specifying times “America/Chicago” or “Australica/Sydney” is known as the Olson Time Zone.
To use US Central Time for the example, CST refers to Central Standard Time and is defined as UTC minus 6 hours, CDT refers to Central Daylight Time and is defined as UTC minus 5 hours. In the winter, we use CST and on the second Sunday in March, we switch to CDT and use it over the summer. On the first Sunday in November, we switch our clocks back. On the list of Olson time zones, this collection of information is called “America/Chicago” meaning we share the same time zone rules as Chicago, Illinois, United States.
Summer: Central Daylight Time (UTC - 5)
Winter: Central Standard Time (UTC - 6)
Spring Switch: Second Sunday in March
Fall Switch: First Sunday in November
Now we finally have enough information to compute the conversion from local time to UTC and back. If we know that a user is in the zone “America/Chicago” we can take the times that they input into time fields and convert to UTC prior to storage. Suppose that is a meeting time that applies to 10 of your users across 10 different time zones. Each of them will see the meeting time in their local time zone because you will convert the time you show them from UTC to their local time when you display it to them or send them email messages.
Whatever language you work in, I recommend looking into the tzdb to see if it is available to you.
For C#, I recommend starting by looking into the tzdb project.