Best practices for storing user time zone - TSQL/.Net
===

I have a need to track user's time zone so processing of their information (or no processing) can happen at specific times they specify (in their own time zone).

The obvious answer is to store the time zone in the user database with their profile information. The thing that is a little tricky is daylight savings. Notice from this image below that most northern and southern regions use a daylight time offset. So storing a time zone offset doesnt feel like it will work, since that offset could change through the year. Instead I'm thinking of storing the time zone code (something like PST) and letting a standard time library lookup the offset.

So a couple things I'm thinking about are:

1) Does TSQL have this library for converting from a time zone code (PST) to a current UTC offset?
2) I know [.net can do this][1], but I'd prefer to do this in the database since that's where my queries will run.


![enter image description here][2]


  [1]: http://www.dotnetperls.com/timezone
  [2]: http://i.stack.imgur.com/DQFAe.png