Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create table yourtable(
- id INT primary key AUTO_INCREMENT,
- start varchar(50)
- );
- INSERT INTO yourtable(start) VALUES('1901-02-03T05:30:00.000Z');
- UPDATE yourtable
- SET start = DATE_FORMAT(STR_TO_DATE(start,'%Y-%m-%dT%H:%i:%s.000Z'),'%Y-%m-%d %H:%i:%s');
- ALTER TABLE yourtable MODIFY COLUMN start datetime;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement