OT: DBs and daylight savings time

2003-10-14 Thread Orin Rehorst
A mainframe db can get messed up when switching from daylight savings time. On the morning of Oct 26 an hour will be ran twice. A transaction could run at 1:15 AM, the hour be changed from 2 to 1 AM, and then another transaction ran after the first but be logged as 1:10 AM. That can mess up

Re: OT: DBs and daylight savings time

2003-10-14 Thread bscott
On Tue, 14 Oct 2003, at 5:20pm, [EMAIL PROTECTED] wrote: A mainframe db can get messed up when switching from daylight savings time. Most systems designed in the past thirty years or so use an absolute counter (the number of seconds since Midnight, 1 Jan 1970 is a popular choice) for time