Datetime timezone adjustments

Question

My database is located in e.g. california. My user table has all the user's timezone e.g. -0700 UTC

How can I adjust the time from my database server whenever I display a date to the user who lives in e.g. new york? UTC/GMT -4 hours

Answer 1

You should store your data in UTC format and showing it in local timezone format.

DateTime.ToUniversalTime() -> server;
DateTime.ToLocalTime() -> client

You can adjust date/time using AddXXX methods group, but it can be error prone. .NET has support for time zones in System.TimeZoneInfo class.