We found something interesting. Non-Issue, just interesting. We have a little test form, unrelated to DST, but has a time converter on it. It converts a timestamp from regular time to EPOCH and vice versa.
I know there is technically no such thing as March 11, 2007 02:00:00, but the conversion for any time on that day between 2:00:00 AM and 2:59:59 AM yields a "3". As in 3 seconds. When converted back, it takes us back to 12/31/1969 06:00:03 PM. That conversion makes sense from 3 seconds-->12/31/1969:06:00:03 PM. But, I would think that 2:00:00 AM to 2:59:59.xxxx AM on a DST Sunday might yield an error. Any Daylight Savings Time Sunday for all years going forward yield the same results. This doesn't affect past dates. This is a non-issue for us, but just thought it was kind of interesting. Strange huh? Enjoy your day. Michelle -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Wednesday, March 07, 2007 2:08 PM To: [email protected] Subject: Re: DST - UK and GMT Time Compare the db values of the two timestamps and see if they are close. If they are off by an hour or more then you have a problem. Remember that all the dates in the db are stored in GMT, regardless of the source of the data. Axton Grams On 3/7/07, Frank Caruso <[EMAIL PROTECTED]> wrote: > ** Scenario: > > ARS Server is EST runnning 6.3 P20 on Solaris (DST patched) /Sybase > MidTier is running 6.3 Patch20 on LINUX, TomCat and Apache > Not using user preference records > Bumped the ARS and Web servers ahead to 3/20/2007 A user in the US on EST > creates a record and the midtier displays the correct created date and time. > > A user in the UK on GMT creates a record in the same table at the same time > but the create date and time is in EST. > > Any thoughts? > > > __20060125_______________________This posting was submitted > with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
