Q:

Datetime colum to float type conversion is getting issue in sql server

I'd like alter a column type from Datetime to float. Hence, I executed the below query but it was getting a issue
alter table dbo.purchasedate
alter column supp_dt float null

Error :: Implicit conversion from data type datetime to float is not allowed. Use the CONVERT function to run this query.

A:

Without knowing your desired output, you could just: Add Float column, populate, drop date column.   
To my knowledge you cannot add a CONVERT to an ALTER statement, anyone know otherwise?

