Discussion Locked

SET TZ= environmental parameter

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

part 1:
I have a Windows Server 2000 that is running software that cannot allow automatic time changes due to daylight savings time. Part of the application is using Oracle 8i to archive data.

part 2:
I have another machine running Windows Server 2003, but is allowed to automatically adjust for DST. The application on this machine is also running data archive software.

Problem:
Machine #2 polls data from machine #1, which during a few months out of the year the data time stamps are in synch. During DST though there is an hour difference.Both machines archiving time stamps are using UTC. So #1 machine is Central Daylight Time w/o UTC bias, and machine #2 is UTC w bias. The tech support guys for machine #2 had me add the SET TZ= parameter to the autoexec.bat file on machine #1.

Now my question:
How does the SET =TZ parameter work? To the clock on the desktop it appears transparent. But what about the Oracle logs on machine #1. Since the time stamp is based off of the system clock (UTC)is there a bias added there that cannot be seen?

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.