On Tue, 6 Sep 2011 08:23:12 -0500, McKown, John <john.mck...@healthmarkets.com> wrote:
>... That is, being in the US Central Timezone, when we go to Daylight Saving >time (from TIMEZONE=W.06 to TIMEZONE=W.05) at 02:00, the time range from >02:00-02:59 repeats. Is this correct? If so, I don't know if 02:10, for >example. is local time for 08:10 or 07:10 GMT. > >Do I just "give up"? Or am I missing something simple? For reader start date/time you would probably need to keep track of when you first saw that date/time combination, and remember whether you were in daylight savings time at that point or not. And then hope that you didn't have a job start during the first 02:00-02:59 interval, and another one start at the exact same time during the second 02:00-02:59 interval. There's another timestamp, though, for the date/time the record was provided to SMF. That one is a bit easier, I think. If you're processing the records from that day sequentially, if you're lucky then when you start getting records from the second 02:00-02:59 interval you'll notice the timestamp move backward, and you would then know that you've crossed the boundary. Of course, you might get unlucky and have no records during the first 02:00-02:59 interval, or have some from that interval but have the ones from the second interval occur late enough that you can't observe the timestamp moving backward. So, there will be some cases you can't determine, I think. -- Walt ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
