472,791 Members | 1,567 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,791 software developers and data experts.

Oracle DST Setting in OpenVMS Version.

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.

Jul 19 '05 #1
0 2342

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: berlioz | last post by:
I'm currently trying to interface CSWS 2.0 (apache) / PHP v1.2 (PHP 4.3.2) with an Oracle 9.2 database under OpenVMS 7.3.2 The database connection works fine, but i've a problem with OCIexecute...
1
by: Pivo Pijem | last post by:
Hey! I have a problem loading (transforming) XML file using DOM XML extension on OpenVMS (alpha). I have installed libxml2, mysql, apache,... following steps described here...
4
by: susmita_ganguly | last post by:
Hi I am trying to upgrade from oracle 8i to oracle 9i on the same server ..I don't know much abt migration . Can anyone help me out. Thanks. Susmita
0
by: Kevin McDaniel | last post by:
Has anyone ever heard of installing Oracle 9.2 on an Alpha OpenVMS box without using OUI? I know the Installation Guide says that ORACLEINS no longer exists, but I'm being told that it is STILL...
3
by: David Gray | last post by:
Hello all, Having problems connecting to an Oracle 9i database from within SQL/Server 2000 using the Security/Linked Servers feature. Server1 (SQL/Server) ----------- Windows Server 2003,...
0
by: Nagi | last post by:
Hi, I'm working for the backup application. Currently we need to support Oracle8i backups for our application. We are having OCI* calls from our code. We are using Recovery Manager: Release...
6
by: hegyvari | last post by:
Hi, I have a few apps written in PHP, running on Fedora Core. After porting these applications from PostgreSQL to Oracle a bug appeared: sometimes, not in a reproducable manner, the web page...
9
by: Irmen de Jong | last post by:
Hi, Recently I was bitten by an apparent bug in the BSD socket layer on Open VMS. Specifically, it appears that VMS defines MSG_WAITALL in socket.h but does not implement it (it is not in the...
0
by: Andoni | last post by:
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...
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.