Is it possible that your table has a pre-insert
trigger that replaces the incoming value
with SYSDATE; but no corresponding
pre-update trigger ?
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.
Antonio wrote in message
<3604814d.0111050423.32fbf0c8_at_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:51:30 CST
