Changing dateType of a column

[ali560045]

i need to change the datType of a column:

below the code i thought will work but it is not.

alter table emp rename column insert_time to time_value1 date default (sysdate)

----------------------------------------------------------------

i know the above query is wrong,can any one provide a good solution

[gopu_g]

check this will work or not....

alter table tablename modify(coumn_name);

[ali560045]

thanks for ur help:

alter table table_name modify column_name datatype

[gopu_g]

you can do it like this..

SQL> create table insert_time(time varchar(20));

Table created.

SQL> alter table insert_time modify(time date);

Table altered.

SQL>