/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

1 vote172 views1 answer
Sql restore backup query
SQL
9 votes172 views1 answer
No sql
SQL
2 votes166 views1 answer
How to select first row of database sql
SQL
19 votes171 views5 answers
Change column name mysql command line
SQL
0 vote175 views1 answer
Top frequency in sql server
SQL
0 vote208 views1 answer
How to add auto increment primary key
SQL
0 vote167 views1 answer
Kotlin sqlite delete row
SQL
16 votes188 views3 answers
Jwt secret key generator laravel
SQL
0 vote167 views1 answer
Sql max min
SQL
9 votes177 views4 answers
How to create new user and database postgresql in ubuntu
SQL