/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

9 votes189 views2 answers
Cmd to rename a collumn name in sql
SQL
11 votes196 views6 answers
Distinct sql
SQL
24 votes205 views5 answers
List mysql users
SQL
1 vote236 views2 answers
Login to mysql
SQL
7 votes178 views1 answer
Safe mode mysql
SQL
7 votes241 views2 answers
Create index mysql cli
SQL
1 vote215 views2 answers
Mysql extract number from string
SQL
0 vote216 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
2 votes243 views1 answer
How to get non distinct values in sql
SQL
-1 vote252 views1 answer
Mysql coalesce
SQL