vinu (5/11/2008)
Hi Q,My current column is having 'text datatype and i want it to change to 'datetime' datatype.....
vinu,
Use the script that Gail posted twice.
ALTER TABLE tablename ALTER COLUMN columnname varchar(max)
ALTER TABLE tablename ALTER COLUMN columnname datetime
this will get you to a datetime from text. text will not convert to datetime directly. .
Q
Please take a number. Now serving emergency 1,203,894