Re: SYSDATE is less than host's time for 4 hours

I was shocked too when I saw my time as -8 on my machine. (Singapore is +8 GMT). However check your TZ environment variable for Oracle I believe it is set as GMT. A normal user on my system has TZ=Singapore.

Adrian Shepherd wrote in message <6o0phd$nj9$1_at_uranium.btinternet.com>...
>Either this is a glaring bug or your Oracle may be set-up to allow for
>timezones if this is at all probable/possible ?
>
>
>Are you by any chance GMT -4 ?
>
>
>Serguei N. Possokhov wrote in message <35A3B1B2.8D2D2583_at_ntvplus.com>...
>>Hi, All !
>>Help me, please ...
>>
>>Oracle 7.3.3 Workgroup Server (for SCO) on FreeBSD 2.2.2.
>>SYSDATE is less than host's DATE for 4 hours.
>>
>>How to set Oracle server's time (SYSDATE)
>>to right (equal to host time) value ?
>>
>>Thanks + Regards.
>>
>>Serguei
>
>
Received on Thu Jul 09 1998 - 00:00:00 CDT