/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 vote191 views1 answer
Mysql workbench search all tables
SQL
1 vote216 views1 answer
Base nosql
SQL
2 votes205 views1 answer
Sql ignore accents
SQL
0 vote213 views1 answer
Compare if is null sql
SQL
1 vote227 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote238 views1 answer
Shrink database file in sql server
SQL
1 vote218 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote239 views1 answer
How to select only a certain date sql
SQL
1 vote203 views1 answer
Clear screen command in psql
SQL
1 vote208 views2 answers
Sql where keyword
SQL