Hi,

I have a oracle source with a field my_date =06/02/2009

I am trying to update the table to SYSDATE with a myscript.sql where I have

UPDATE table set my_date=to_DATE(SYSDATE,'MM/DD/YYYY');

Now I try to run it with myupdate.SH script where I have

sqlplus nolog @myscript.sql

But here I have a peculiar problem when I run the script in oracle it updates the table but when I run with this script myupdate.SH it gives me a error not a valid month.

Is there any way I can solve this. or any way I can connect to my oracle table and update the date field to SYSDATE in mm/dd/yyyy format. Pls help.Thanks

sqlplus -s <<!
login/passwd@db
set heading off pause off termout off verify off feedback off pagesize 0 linesize 150
update <table> set my_date=to_char(SYSDATE,'MM/DD/YYYY');
!`

Rakesh,

I didn't get it...is it that without

set heading off pause off termout off verify off feedback off pagesize 0 linesize 150

update statement won't work..why is it?

Not like that, your query was wrong. see the to_char in bold.

But I dont want my oracle table datatype to change to char...I want to keep it as date and also I tried ur solution ,,,it still gives me the same problem