DateTimeOffset - Loading historical data

• Vince Poirier

  SSC Eights!

  Points: 932

  More actions

  August 12, 2014 at 2:56 pm

  #294368

  Hello,

  I want to load historical data from an old system into a new one.

  Thing is, that old system stored dates as Datetime and the new one uses DateTimeOffset.

  All data was collected in the same Time Zone... but with the Daylight Saving Time (DST)

  The offset is either +04:00 or +05:00, based on the calendar date.

  To add to the complexity, the rules for DST changed a couple of years ago.

  To determine the offset, I'd need to know what was or would have been the server Timezone for each historical date.

  Any ideas ?

  Thanks,

  Vince

• Eirikur Eiriksson

  SSC Guru

  Points: 182911

  More actions

  August 12, 2014 at 9:06 pm

  #1737414

  Suggest you have a look at the Time Zone Database, holds time zones and time change history.

  😎