/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

0 vote99 views3 answers
Convert sql query to python pandas
SQL
103 votes258 views1 answer
Like sql
SQL
3 votes121 views1 answer
Force using index oracle
SQL
1 vote107 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes99 views1 answer
Update with join sql server
SQL
0 vote105 views1 answer
Sql tabelle erstellen
SQL
1 vote103 views1 answer
Count mysql server db tables
SQL
0 vote108 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote101 views1 answer
Mysql undo delete
SQL
0 vote113 views1 answer
Get schema of table sql
SQL