After digging into the TimeZoneInfo class, John Meyer pointed me a the new DateTimeOffset class and a MSDN article on choosing between DateTime, DateTimeOffset and TimeZoneInfo classes. I think I am more confused by the article than before. Here are a couple of key bits of information:
The article goes on to say two confusing statements:
Although the DateTimeOffset type includes most of the functionality of the DateTime type, it is not intended to replace the DateTime type in application development.
DateTimeOffset should be considered the default date and time type for application development.
I think I understand it, but it is very confusing. In addition, its unclear how this relates to database data (I don’t think there is a data type in SQL Server that encompasses offset and date/time information.)