/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 vote201 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
4 votes194 views1 answer
Data types in sql
SQL
0 vote197 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote197 views1 answer
Sql change primary key to composite key
SQL
0 vote196 views1 answer
Delete duplicate rows
SQL
2 votes186 views1 answer
Sqlite show table indexes
SQL
18 votes218 views2 answers
Sql comments
SQL
8 votes208 views2 answers
Oracle undo usage
SQL
19 votes204 views6 answers
Sql create table
SQL
1 vote173 views1 answer
Ms sql - add one hour to time
SQL