Oracle DST Setting in OpenVMS Version.

From: Andoni <no_spam_please_at_andoni-at-ireland-dot-com.com>
Date: Thu, 11 Nov 2004 18:44:11 -0000
Message-ID: <_pOkd.41629$Z14.16594@news.indigo.ie>

Hello,

Does anybody use Oracle 9i for OpenVMS? Do you have to change the logical name:

"SYS$TIMEZONE_DIFFERENTIAL" = "3600" twice a year, when the clocks go back or forwards?

We have found that Oracle does not seem to see the ordinary operating system time but rather is adding this value to real time (winter time) so we have to put it in place in Spring and set it to zero in Autumn/Fall.

Surely there is a better way?

Thanks in advance for any help you may be able to give.

Andoni. Received on Thu Nov 11 2004 - 12:44:11 CST