如何在不丢失日期的情况下将varchar列类型转换为日期类型

您将需要根据您的确切表结构来调整它，但是类似的东西；

CREATE TABLE temp (startdate varchar(255), stuff varchar(255));INSERT INTO tempSELECt startdate,stuffFROM mytable;TRUNCATE TABLE mytable;ALTER TABLE mytable ALTER COLUMN startdate DATETIME NOT NULL;INSERT INTO mytableSELECt CAST(startdate AS DATETIME), stuff FROM temp;DROP TABLE temp;