/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

92 votes1.5K views6 answers
Substring
SQL
27 votes274 views3 answers
Mysql delete row
SQL
6 votes168 views3 answers
What is where in sql
SQL
1 vote142 views1 answer
Oracle sql create view
SQL
17 votes208 views2 answers
How to assign date field for table in mysql
SQL
0 vote174 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote167 views1 answer
How to drop a trigger in postgresql
SQL
0 vote148 views1 answer
Get week day name sql server
SQL
-1 vote158 views1 answer
How to reset autoincrement in sqlite java
SQL
1 vote156 views3 answers
Drop unique key constraint in sql server
SQL