CODEWITHSUNDEEP
.netsql-serverdatetimetimezone
user210132
user210132

Reputation: 11

Converting asp.net/sql web app to be ime zone savy

Our current app stores all dates via the server's datetime. I'm thinking we need to update all datetime values in the database over to UTC time.

Now for displaying these dates back to the user, I know .Net 3.5 has datatypes that are specific to date time offsets. But does anyone see anything wrong with setting an application variable to represent the desired time zone for the site, and then do a dateadd with that offset to display times back to the user? For instance the Eastern Time zone would have a value of "-5".

Upvotes: 1

Views: 155

Answers (4)

Eric Z Beard
Eric Z Beard

Reputation: 38426

In the latest version of .NET you get the TimeZoneInfo class that helps with converting dates.

You store the dates in GMT, also store the user's time zone, and then convert the dates each time you need to display them. The hard part is dealing with daylight savings time. The TimeZoneInfo class should help with this. Before that class was available you had to do it all yourself, storing tables of data on time zones and the date ranges of daylight savings time in each time zone.

Upvotes: 0

Damir Sudarevic
Damir Sudarevic

Reputation: 22187

Well, as long as you handle daylight savings "properly". Other than that, if your DB has anything to do with web, records should definitively store UTC. UTC does not "jump" on daylight savings time, so there is no trouble with sorting records entered during time change and datediff calculus is always ok.

Upvotes: 0

Mike Atlas
Mike Atlas

Reputation: 8231

Have a look at Coding Best Practices using DateTime in the .NET Framework. It isn't a tough read and you'll thank yourself for implementing them this way down the road - for example, you won't have to deal with daylight savings changes if you use .NET's provided timezone handling, for example.

Upvotes: 0

cdonner
cdonner

Reputation: 37668

Sounds like to you want to re-invent the wheel. If the application is a web app or geographically distributed, you need to know the time zone of the users. Knowing the server's correct time may not be helpful to them.

See this question for a code example:

How to render local time given UTC datetime values in ASP.Net without using Javascript?

Upvotes: 1

Related Questions