Converting Historical DateTime from GMT-PST Including DST.
Posted on 2007-11-28
Client has 60+ years historical data that includes Date_Time stamp on records. The Date_Time stamp was stored relative to GMT. The GMT Date_Time stamp was recorded in the historical records which were, and remain, in the PST zone.
Client needs historical data converted. The legacy Date_Time stamp of the historical data needs to NOW be stored as a Date_Time stamp in United States PST.
The Date_Time stamp must reflect (any?) impact that DST may have created since the imposition of the Uniform Time Act of 1966 (15 U.S. Code Section 260a). Is there any impact? If so, would it be necessary to account for DST issues in BOTH GMT and PST regions (relative to the Date_Time stamp in a historical data record) since 1966?
I know it is a somewhat odd question and perhaps overly worded; however, inasmuch as technical and potential legal/accuracy/logistical issues may be involved, I would like additional viewpoints and/or facts. Perhaps it is a simple or irrelevant question in the final analysis.
Depending on the response, I may post a separate follow up question to solicit a generic algorithm to code a solution. But first things first.
Thanks so much for all of the forthcoming comments.