/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 vote338 views5 answers
Left join
SQL
0 vote324 views1 answer
Mysql c commands
SQL
-1 vote345 views1 answer
Pl/sql how to delete a trigger
SQL
0 vote345 views1 answer
Sql: extract day text from datetime value
SQL
0 vote331 views1 answer
Mysqli last row
SQL
14 votes320 views4 answers
Online sql compiler
SQL
10 votes300 views1 answer
All_dependencies
SQL
1 vote306 views1 answer
Sql server update column based on another table
SQL
14 votes331 views2 answers
Oracle add column with default value
SQL
2 votes308 views1 answer
Import large .sql files into lampp
SQL