How to modify table column date formate
venkatMay 2 2008 — edited May 2 2008Hi,
I have a table with database column EFFECT_FROM. its a varchar datatype, current date formate is YYY/MM/DD-HH:MM:SSS. I want to change as a MM/DD/YY.
example: 2007/08/30-12:00:00:000
I used one query like---
alter table test_venkat modify(to_char((to_date(revf.dateeffectivefrom,'YYYY/MM/DD')),'MM/DD/YYYY')Partfrom)
error occoured .
ORA-00902: invalid datatype
How to handle this problem, pls guide me.
Thanks & Regards,
Venkat