Re: Daylight Savings and Logs

In article <4iqc44$33j@osa04.firststate.com.au>, vanwegen@firststate.com.au says... > >We here in Australia(Sydney) are about to set our clocks back one hour >on 31/3/1996 at 03:00. >What implications are there regarding the logs. >We plan to stop our databases at 03:00 and leave them down for an >hour. Does anyone have any other suggestions. We are worried about >restore implications as the log timestamps would go from 3:00 back to >2:00. > You didn't mention what operating system you are using. If you are using UNIX, I suggest that you check out that different time zone parameters. We use EST5EDT, which automatically translates the UNIX time (which is kept in coordinated universal time) to the local time zone. See the manpages on 'tztab' for more information. Therefore, the time never gets changed on the UNIX platform, only the translation. 'Smart' UNIX programs know this and bypass the time zone for time stamps. However, you can bypass this by setting the UNIX time to the local time and not using time zones at all. So it depends on how your system is set up.