How to convert a varchar column type to date type without losing the dates

by

You will need to adapt this based your your exact table structure but something like;

CREATE TABLE temp (startdate varchar(255), stuff varchar(255));

INSERT INTO temp
SELECT startdate,stuff
FROM mytable;

TRUNCATE TABLE mytable;

ALTER TABLE mytable ALTER COLUMN startdate DATETIME NOT NULL;

INSERT INTO mytable
SELECT CAST(startdate AS DATETIME), stuff FROM temp;

DROP TABLE temp;

More Related Contents:

  1. SQL Print the name of all Employees together with the name of their supervisor
  2. MySQL – Rows to Columns
  3. ROW_NUMBER() in MySQL
  4. MySQL offset infinite rows
  5. Ordering by the order of values in a SQL IN() clause
  6. SQL Selecting from two Tables with inner join and limit [duplicate]
  7. MySQL Group by SUM
  8. Get the latest date from grouped MySQL data
  9. MySQL Error 1264: out of range value for column
  10. How to change the default port of mysql from 3306 to 3360
  11. Special Characters in MySQL Table Name
  12. Is it possible to reference one column as multiple foreign keys?
  13. MySQL: How do I join same table multiple times?
  14. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  15. Empty IN clause parameter list in MySQL
  16. creating a random number using MYSQL
  17. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  18. How to speed up sql queries ? Indexes?
  19. MySQL – why not index every field?
  20. mysql count group by having
  21. MySQL: Insert datetime into other datetime field
  22. SQL UPDATE with sub-query that references the same table in MySQL
  23. Selecting distinct 2 columns combination in mysql
  24. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  25. How to store a one to many relation in MySQL database?
  26. Why in SQL NULL can’t match with NULL?
  27. MySQL – Complexity of: SELECT COUNT(*) FROM MyTable;
  28. MySQL: Computed Column
  29. mySQL query to search all tables within a database for a string?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment