SYSDATE strange behaviour
From: Martin Terpstra <terpstra_at_ats.nld.alcatel.nl>
Date: 1998/04/02
Message-ID: <3523A464.1CC010A0_at_ats.nld.alcatel.nl>#1/1
Oracle | machine with the oracle server | remote machine tool | runs on TZ=local(GMT+2) |
Date: 1998/04/02
Message-ID: <3523A464.1CC010A0_at_ats.nld.alcatel.nl>#1/1
hello,
[Quoted] TZ = environment variable on unix which indicates
the local timezone.
GMT = Greenwich Mean Time
The situation:
There are two unix machines.
On one machine the oracle database server is running in local timezone.
When starting different oracle tools on both machines we get different
values for the SYSDATE value !!
Oracle | machine with the oracle server | remote machine tool | runs on TZ=local(GMT+2) |
SQLPLUS | TZ=GMT | TZ=GMT
| select sysdate from dual | select sysdate from dual
| returns: GMT (not server) time | returns: local (=server) time
------------------------------------------------------------------ FORMS | TZ=GMT | TZ=GMT
| sysdate in forms | sysdate in forms
| returns: local(=server) time | returns: local(=server) time
------------------------------------------------------------------ REPORTS | TZ=GMT | TZ=GMT
| sysdate in report | sysdate in report
| returns: GMT (not server) time | returns: GMT (not server) time
------------------------------------------------------------------
What is going on??
please also respond to my Email.
Thank you.
-- Martin Terpstra Alcatel Telecom Nederland Software Design Engineer Engineering & Development phone : +31 (70) 307-9407 Burgemeester Elsenlaan 170 fax : +31 (70) 307-9191 2288 BH RIJSWIJK mailto:terpstra_at_ats.nld.alcatel.nl NETHERLANDSReceived on Thu Apr 02 1998 - 00:00:00 CEST