Re: SYSDATE vs CURRENT_DATE
From: Samuel Guiñales Cristobal <samuel.guinales_at_gmail.com>
Date: Tue, 28 Feb 2012 13:59:30 +0100
Message-ID: <CAF=AZ3C11kUFaAM6BmpVf80VS1hp7PVxwtfJveBk7CYx4VcDBA_at_mail.gmail.com>
> 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.
Date: Tue, 28 Feb 2012 13:59:30 +0100
Message-ID: <CAF=AZ3C11kUFaAM6BmpVf80VS1hp7PVxwtfJveBk7CYx4VcDBA_at_mail.gmail.com>
> 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.
Philip Jones thanks!, you put finish a great headache, really thanks,
--- Samuel Guiñales Cristobal <samuel.guinales_at_gmail.com> «La vida es breve; el arte, largo; la ocasión, fugaz; la experiencia, engañosa; el juicio, difícil.» Hipócrates, Aforismos, I, 1 On 28 February 2012 13:30, Phillip Jones <phil_at_phillip.im> wrote:Received on Tue Feb 28 2012 - 06:59:30 CST
> 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