I had fix the problemmm.

As per my understanding we can't alter a datetime column directly into numeric type. So I convert frist into varchar(8) then to Numeric.

Thanks for your reply..................