error in changing data type
i have a table test with column data and datatype is varchar2(35).In this date value is stored
now i want to change the datatype to timestamp(3)
i am changing as below
ALTER table test
ADD testcolumn timestamp(3);
its adding column
UPDATE test
SET testcolumn = data;
but its giving error not a valid month