/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 vote174 views1 answer
Sql inserted
SQL
1 vote192 views1 answer
Oracle transaction rollback not working
SQL
2 votes176 views1 answer
Q operator in sql
SQL
1 vote183 views3 answers
Connection string mysql
SQL
2 votes175 views1 answer
Oracle list grants on procedure
SQL
0 vote176 views2 answers
Mysql get routine parameter list
SQL
2 votes183 views1 answer
Set username and password for postgresql database
SQL
0 vote185 views1 answer
Postgresql print variable
SQL
1 vote195 views1 answer
Sql select max value from multiple rows
SQL
3 votes173 views2 answers
Coalesce mysql
SQL