/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 vote337 views1 answer
Amount of entries in a table psql
SQL
0 vote303 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote325 views2 answers
Oracle list service names
SQL
0 vote320 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
1 vote328 views5 answers
Postgresql difference between two dates in days
SQL
9 votes311 views2 answers
Cmd to rename a collumn name in sql
SQL
12 votes310 views4 answers
Import mysql database command line linux
SQL
3 votes304 views2 answers
How to start postgresql on windows
SQL
0 vote291 views1 answer
Mysql database is not starting in xampp
SQL
0 vote295 views1 answer
Inner joint
SQL