Re: LOCALTIMESTAMP oracle9i

From: Jusung Yang <JusungYang_at_yahoo.com>
Date: 20 Sep 2002 10:27:53 -0700
Message-ID: <130ba93a.0209200927.6a4f8f6a_at_posting.google.com>

What is your OS? No problem on WinXp.

SQL> insert into tyu(c1) values(1);

1 row created.

SQL> select c1, to_char(c2,'ddmmyy hh24:mi:ss') from tyu;

        C1 TO_CHAR(C2,'DDM
---------- ---------------

         1 200902 10:21:06

SQL> select current_timestamp, localtimestamp from dual;

CURRENT_TIMESTAMP

---

LOCALTIMESTAMP

---

20-SEP-02 10.21.23.331000 AM -07:00
20-SEP-02 10.21.23.331000 AM severini.simone_at_vizzavi.it (Simone) 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 Fri Sep 20 2002 - 19:27:53 CEST