/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 vote120 views1 answer
Openquery insert into linked server
SQL
1 vote141 views2 answers
Restart identity cascade
SQL
0 vote132 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote153 views1 answer
Oracle step procedure
SQL
1 vote131 views2 answers
T-sql random number for each row
SQL
-1 vote140 views2 answers
Mysql get day of week
SQL
1 vote142 views1 answer
Show table status command in mysql
SQL
0 vote132 views1 answer
C# get sql min date
SQL
0 vote116 views5 answers
Sql table intermédiaire
SQL
0 vote122 views1 answer
Mysql autoincrement valor inicial
SQL