Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dates in oracle 8i

Dates in oracle 8i

From: Antonio <nickanto_at_netscape.net>
Date: 5 Nov 2001 04:23:08 -0800
Message-ID: <3604814d.0111050423.32fbf0c8@posting.google.com>


Hi!

   I am making an insert from sqlplus into a table that have a date column. I use the TO_DATE function like:   insert into t1 (v1,v2,d1) values (1,2,to_date('09/04/2001 10:23:08','DD/MM/YYYY HH24:MI:SS'));
  Insert goes well excepting that the date inserted is the sysdate.  

 v1 v2 d1



1 2 05-NOV-2001   If I make an update, it works well ...  update t1 set d1=to_date('09/04/2001 10:23:08','DD/MM/YYYY HH24:MI:SS');

 v1 v2 d1



1 2 09-APR-2001   Somebody knows why it happens????

   Thanx in advance! Received on Mon Nov 05 2001 - 06:23:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US