/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 vote299 views1 answer
Mysql connect bash
SQL
3 votes309 views5 answers
Sql select
SQL
0 vote261 views1 answer
Stop psql server windows
SQL
1 vote288 views1 answer
Mysql get domain from url
SQL
0 vote270 views2 answers
Android sqlite tutorial for beginners
SQL
13 votes469 views4 answers
Sql joining 3 tables
SQL
17 votes269 views5 answers
Order by sql
SQL
0 vote287 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote279 views1 answer
Postgres execute multiple sql file from command line
SQL
15 votes276 views2 answers
Select Options
SQL