TO_DATE question in insert

From: Manser <nmanser_at_progis.de>
Date: 16 Jul 2003 04:17:16 -0700
Message-ID: <2178d61f.0307160317.31c77c66@posting.google.com>

Hi oracle folks,

I have done the following insert statement:

the datatype of datum_upd is DATE.

SQL> insert into manser.previsions (cell,datum_upd,idnr) values   2 (44,TO_DATE ('15-JUL-2003 1:00','DD-MON-YYYY HH24:MI'),60390); 1 row created.

when i query it the date format is not what i expect .

SQL> select datum_upd from manser.previsions where cell = 44;

DATUM_UPD

---

15-JUL-03 SQL> exit
Disconnected from Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning and Parallel Server options JServer Release 8.1.7.0.0 - Production

why is the query result not in the wanted form ? i would expect the following query result:

DATUM_UPD

---

15-JUL-2003 1:00 can anyone give me some explanations ?
i am running oracle 8.1.7 under openVMS alpha 7.3. great thanks in advance.

Nazim Manser Received on Wed Jul 16 2003 - 06:17:16 CDT