Re: SYSDATE vs CURRENT_DATE
- From: Phillip Jones <phil@xxxxxxxxxx>
- To: samuel.guinales@xxxxxxxxx
- Date: Tue, 28 Feb 2012 12:30:40 +0000
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@xxxxxxxxx>
> 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
Other related posts: