update query help plz

[whtisthat]

SELECT * FROM FND_CONCURRENT_REQUESTS WHERE REQUEST_ID= 007

update statment for argument14,argument15,and ARGUMENT_TEXT
which is '1, 1, MSTK, CUSTOMER_NAME, USC, D, , , , , , , , 01-FEB-04, 05-FEB-04, USD, N, N'

need to update inside ARGUMENT_TEXT the date to_char and to_date
and argument14 and argument15 is char but data is date

Thanks in advance

 

[smart99]

Insert the date as using sysdate, when using that column again in use to date to convert as date.

TAKING AN EXAMPLE TABLE TEST2 WITH column a as varchar column.

Eg : insert into test2 values (sysdate);

A
---------
23-AUG-04

SQL> select to_date(a,'DD-MON-YY') FROM TEST2
2 /

TO_DATE(A
---------
23-AUG-04