How to work with time zones in ASP.NET?

by

First thing is to make sure which time zone your data is in. I would recommend making sure that any DateTime that you store, is stored in UTC time (use the DateTime.ToUniversalTime() to get hold of it).

When you are to store a reminder for a user, you will need the current UTC time, add or remove the user’s time zone difference, and convert that new time back to UTC; this is what you want to store in the DB.

Then, when you want to check for reminders to send, you simply need to look in the database for reminders to send out now, according to UTC time; essentially get all reminders that have a time stamp that is before DateTime.Now.ToUniversalTime().

Update with some implementation specifics:
You can get a list of time zones from the TimeZoneInfo.GetSystemTimeZones() method; you can use those to show a list of time zones for the user. If you store the Id property from the selected time zone, you can create a TimeZoneInfo class instance from it, and calculate the UTC time for a given local date/time value:

TimeZoneInfo tzi = TimeZoneInfo.FindSystemTimeZoneById("<the time zone id>");
// May 7, 08:04:00
DateTime userDateTime = new DateTime(2009, 5, 7, 8, 4, 0);
DateTime utcDateTime = userDateTime.Subtract(tzi.BaseUtcOffset);

More Related Contents:

  1. How to convert datetime to timestamp using C#/.NET (ignoring current timezone)
  2. Getting system Timezones in different languages
  3. How to get Windows Explorer type look and feel inside my Application? [closed]
  4. List of Timezone IDs for use with FindTimeZoneById() in C#?
  5. Serializing a list to JSON
  6. Best way in asp.net to force https for an entire site?
  7. Entity Framework Refresh context? [closed]
  8. Can I get more than 1000 records from a DirectorySearcher?
  9. Clearing Page Cache in ASP.NET
  10. prevent property from being serialized in web API
  11. Resizing an image in asp.net without losing the image quality
  12. How to export a JQgrid data to Excel using c#?
  13. Absolute path back to web-relative path
  14. Accessing Office Word object model through asp.net results in “failed due to the following error: 80070005 Access is denied.”
  15. Can I turn off impersonation just in a couple instances
  16. How to implement “Access-Control-Allow-Origin” header in asp.net
  17. How can I export a GridView.DataSource to a datatable or dataset?
  18. how to convert NameValueCollection to JSON string?
  19. Easiest way to parse “querystring” formatted data
  20. ASP.NET File Upload
  21. asp.net Button OnClick event not firing
  22. Multiples Table in DataReader
  23. Redirect to another page when user is not authorized in asp.net mvc3
  24. Change cell color on different values – Gridview
  25. Detect Browser Close on Asp.net
  26. Built-in helper to parse User.Identity.Name into Domain\Username
  27. Are static variables thread-safe? C#
  28. Multiple signalR connections/hubs on your website
  29. ASP.NET – AppDomain.CurrentDomain.GetAssemblies() – Assemblies missing after AppDomain restart
  30. Can I reuse HttpWebRequest without disconnecting from the server?

Leave a Comment