Re: SYSDATE vs CURRENT_DATE

From: Phillip Jones <phil_at_phillip.im>
Date: Tue, 28 Feb 2012 12:30:40 +0000
Message-ID: <CAOyzJudJbVRpwtJ5R=AErj1xQvrRr39L+QTEEKj9c+69jz9wKw_at_mail.gmail.com>

Hi,
This will be due to the setting of the TZ environment variable when the listener was started - it'll probably differ from your current Unix session TZ setting.

See Metalink document 227334.1, section "A complete overview of the TZ (sysdate) behavior on Unix platforms" for a detailed description.

Cheers,

Phil

2012/2/28 Samuel Guiñales Cristobal <samuel.guinales_at_gmail.com>

> The time zone in the server:
>
> echo $TZ -> MET-1METDST
>
> In the database:
>
> SQL> alter session set nls_date_format='DD-MON-YYYY hh24:mi:ss';
>
>
> SQL> SELECT DBTIMEZONE FROM DUAL;
>
> DBTIME
> ------
> +01:00
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 28 2012 - 06:30:40 CST