/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

5 votes212 views1 answer
Mysql get last day of month
SQL
1 vote281 views4 answers
How to check table in postgresql from terminal
SQL
79 votes407 views6 answers
Grepper code
SQL
0 vote252 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote229 views2 answers
Oracle create tablespace autoextend
SQL
0 vote336 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
22 votes255 views3 answers
How to join three tables in sql using joins
SQL
2 votes244 views1 answer
Mysql shell insert into
SQL
0 vote238 views1 answer
To_date sql
SQL
2 votes223 views6 answers
In in sql
SQL