Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error in changing data type

user11221081Sep 10 2009 — edited Sep 10 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2009
Added on Sep 10 2009
3 comments
269 views