/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 vote261 views1 answer
Postgresql blocked on mac
SQL
4 votes224 views1 answer
Install postgres 12 on ubuntu
SQL
-1 vote273 views8 answers
Create Trigger in phpMyAdmin
SQL
1 vote240 views1 answer
How to delete record sql delphi
SQL
0 vote217 views1 answer
Bigquery information_schema schema all columns
SQL
0 vote279 views1 answer
Grant privileges of databse to user
SQL
0 vote281 views1 answer
Mysql dump with table query
SQL
0 vote246 views1 answer
How much table store postgres
SQL
0 vote249 views1 answer
Excute raw query
SQL
1 vote267 views1 answer
Wherein mysql
SQL