Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!colt.net!easynet-quince!easynet.net!feed4.jnfs.ja.net!jnfs.ja.net!feeder.news.heanet.ie!news.indigo.ie!not-for-mail
From: "Andoni" <no_spam_please@andoni-at-ireland-dot-com.com>
Newsgroups: comp.databases.oracle
Followup-To: comp.os.vms
Subject: Oracle DST Setting in OpenVMS Version.
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
Message-ID: <_pOkd.41629$Z14.16594@news.indigo.ie>
Date: Thu, 11 Nov 2004 18:44:11 -0000
NNTP-Posting-Host: 213.94.193.34
X-Complaints-To: abuse@eircom.net
X-Trace: news.indigo.ie 1100198650 213.94.193.34 (Thu, 11 Nov 2004 18:44:10 GMT)
NNTP-Posting-Date: Thu, 11 Nov 2004 18:44:10 GMT
Organization: Eircom.Net http://www.eircom.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle:29087

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.