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