/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

6 votes215 views3 answers
Create database mysql utf8
SQL
0 vote215 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
0 vote234 views1 answer
Get create sql of hibernqte entity
SQL
0 vote234 views1 answer
Count number of entires by months sql
SQL
1 vote212 views2 answers
Procedure syntax
SQL
0 vote200 views4 answers
Change schema in sql server
SQL
0 vote230 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote238 views1 answer
Html css mobile menu arrow dropdown
SQL
1 vote206 views1 answer
SQL Integer devision
SQL
0 vote189 views1 answer
Forcefully delete a row in mysql which has references
SQL