Hi Team, i have to Alter a column in datetime datatype from timestamp datatype ? I Run the script : > Alter Table lav_gltrxdet Alter Column timestamp datetime NULL i am getting the error : Msg 4928, Level 16, State 1, Line 1`` Cannot alter column 'timestamp' because it is 'timestamp'. Is there any to change the datatype Thanks Basit
http://sql-server-performance.com/Community/forums/p/11185/55417.aspx) A timestamp can't be changed or converted once it's set. It doesn't store the actual date/time that a record was added, but rather only a "this happened before that" statement. If you want to change the column type, you would need to drop the column and re-create it. You could, by the way, run the following query: select CONVERT(datetime, [Timestamp Column], 101) from [Your Table] This is the closest that you can get to converting a timestamp value to a datetime, but it certainly won't convert the value to the **correct** date. It might be helpful in seeding for the new datetime column, however.