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,

[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