/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

2 votes173 views1 answer
Show max_allowed_packet mysql
SQL
0 vote133 views1 answer
Postgresql where clause not working
SQL
2 votes143 views2 answers
Mysql count rows returned
SQL
0 vote181 views1 answer
Ms sql print more than 1 variable
SQL
0 vote141 views1 answer
Match end of string regex sql
SQL
0 vote156 views1 answer
On delete set default
SQL
-1 vote143 views1 answer
What is in operator
SQL
0 vote137 views1 answer
Grant privileges of databse to user
SQL
1 vote142 views1 answer
Date_part mysql
SQL
0 vote129 views1 answer
Create table employees oracle
SQL