Cannot alter column 'CreatedOn' because it is 'timestamp'
CREATE TABLE MyTable1(
Name VARCHAR(20),
CreatedOn TIMESTAMP DEFAULT GETDATE()
)
INSERT INTO MyTable1(Name,CreatedOn) VALUES('Najmul',GETUTCDATE())
SELECT Name,CONVERT(DATETIME,CreatedOn) FROM MyTable
ALTER TABLE MyTable ALTER COLUMN CreatedOn DATETIME
Msg 4928, Level 16, State 1, Line 1
Cannot alter column 'CreatedOn' because it is 'timestamp'.