/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 vote135 views1 answer
Oracle archivelog usage
SQL
-1 vote139 views1 answer
Window functions in sql
SQL
0 vote141 views1 answer
Mysql root permission denied lost
SQL
11 votes88 views1 answer
Reset identity sql server
SQL
1 vote133 views1 answer
Update from select join
SQL
1 vote139 views1 answer
Sql current timestamp
SQL
0 vote133 views1 answer
Execute sql stored procedure in powershell
SQL
4 votes132 views1 answer
Oracle show error line number
SQL
6 votes137 views3 answers
Oracle all dates between two dates
SQL
0 vote134 views1 answer
Connexion mysql
SQL