/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 vote312 views1 answer
How to use select union and loop
SQL
0 vote182 views1 answer
Sql query to find duplicate email address
SQL
0 vote163 views2 answers
Sqlite unix timestamp
SQL
0 vote166 views1 answer
C# check if mysql query modified rows
SQL
0 vote176 views1 answer
Insert using condition postgres
SQL
0 vote152 views1 answer
Difference between cross apply and inner join
SQL
0 vote161 views1 answer
Sql server inner join convert collation
SQL
0 vote205 views1 answer
Mysql order by where condition sub query
SQL
4 votes255 views4 answers
Update select mysql
SQL
1 vote172 views1 answer
Sql padd let with zeros
SQL