/SQL/Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

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');

Source: stackoverflow.com

Similar codes

1 vote182 views1 answer
Date_part mysql
SQL
0 vote205 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
4 votes261 views2 answers
Convert utc to est sql
SQL
0 vote283 views1 answer
Oracle db get table sizes
SQL
0 vote181 views1 answer
Run postgresql dump to csv
SQL
23 votes200 views4 answers
Uninstall postgresql ubuntu
SQL
0 vote189 views1 answer
Ajouter une clé etrangere mysql
SQL
2 votes208 views2 answers
Storing timezones in postgres
SQL
0 vote201 views1 answer
Mysql insert into select with recursive
SQL
0 vote189 views1 answer
Install sql server windows 10
SQL