Re: SYSDATE strange behaviour

Hi,

check the timezone settings for oracle on the server as well as on the client.

On Thu, 02 Apr 1998 16:44:52 +0200, Martin Terpstra <terpstra_at_ats.nld.alcatel.nl> wrote:

>hello,
>
>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 NETHERLANDS

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de