Re: LOCALTIMESTAMP oracle9i
Date: Fri, 20 Sep 2002 23:44:42 GMT
Message-ID: <KpOi9.2446$7i2.76_at_nwrddc02.gnilink.net>
Have you set the Global environment variables ORA_TZ to your time zone and
ORA_TZFILE to the ORACLE_HOME/oracore/zoneinfo/timezone.dat file you need to
use?
tED
"Simone" <severini.simone_at_vizzavi.it> wrote in message
news:2f56752e.0209200105.13ab3746_at_posting.google.com...
> Hi,
> I have a table with a field called CURRENT_DATE (datatype DATE)
> and DEFAULT value set to LOCALTIMESTAMP.
> The problem is that when my application INSERT a new record Oracle
> store the correct date but wrong time (-2 houres).
>
> SQL> select current_timestamp, localtimestamp from DUAL;
>
> CURRENT_TIMESTAMP
> --------------------------------------------------------------------------
-
> LOCALTIMESTAMP
> --------------------------------------------------------------------------
-
> 20-SEP-02 11.03.09.000001 AM +02:00
> 20-SEP-02 11.03.09.000001 AM
>
> This time is correct but Oracle doesn't store it (this time minus 2
> houres).
>
> Any idea?
>
> Thanks
Received on Sat Sep 21 2002 - 01:44:42 CEST