Re: SYSDATE vs CURRENT_DATE
- From: Samuel Guiñales Cristobal <samuel.guinales@xxxxxxxxx>
- To: Phillip Jones <phil@xxxxxxxxxx>
- Date: Tue, 28 Feb 2012 13:59:30 +0100
> 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@xxxxxxxxx>
«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@xxxxxxxxxx> wrote:
> 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
>>
>>
>>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
