LOCALTIMESTAMP oracle9i
From: Simone <severini.simone_at_vizzavi.it>
Date: 20 Sep 2002 02:05:47 -0700
Message-ID: <2f56752e.0209200105.13ab3746_at_posting.google.com>
Hi,
LOCALTIMESTAMP
20-SEP-02 11.03.09.000001 AM +02:00
20-SEP-02 11.03.09.000001 AM [Quoted] This time is correct but Oracle doesn't store it (this time minus 2 houres).
Date: 20 Sep 2002 02:05:47 -0700
Message-ID: <2f56752e.0209200105.13ab3746_at_posting.google.com>
Hi,
[Quoted] [Quoted] 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 [Quoted] This time is correct but Oracle doesn't store it (this time minus 2 houres).
Any idea?
Thanks Received on Fri Sep 20 2002 - 11:05:47 CEST