Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Dates in oracle 8i
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
v1 v2 d1
Thanx in advance! Received on Mon Nov 05 2001 - 06:23:08 CST