/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 vote204 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote194 views1 answer
Dump only schema
SQL
0 vote194 views2 answers
Sql searching via key word
SQL
0 vote230 views1 answer
Netstat -tln mysql
SQL
0 vote201 views1 answer
Mysql server not running
SQL
1 vote257 views1 answer
How not to sort by average rating
SQL
0 vote198 views1 answer
Call function sql oracle
SQL
0 vote230 views1 answer
Postgresql custom order by
SQL
10 votes185 views2 answers
Mysql select timestamp group by day
SQL
0 vote203 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL