Just store the data in UTC, and use a calendar tableuse a calendar table to calculate offsets when you read the data (see these tips: part 1part 1, part 2part 2, part 3part 3). Related Q & A:
Daylight saving time and time zone best practices
Best Practices working with Datetimeoffset
how to convert all datetime columns in a sql server 2005 express database with data to UTC
Where to set a UTC datetime value in n-tier application: Presentation Layer, Domain, or Database?
How do I handle the timezones for every Chat message
- GET UTC Date of a past date
- Daylight saving time and time zone best practices
- Best Practices working with Datetimeoffset
- how to convert all datetime columns in a sql server 2005 express database with data to UTC
- Where to set a UTC datetime value in n-tier application: Presentation Layer, Domain, or Database?
- How do I handle the timezones for every Chat message
