/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

3 votes303 views1 answer
Oracle nextval
SQL
0 vote329 views1 answer
Null column as zero in mysql
SQL
17 votes320 views6 answers
Sql select distinct
SQL
1 vote316 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote339 views2 answers
Add colum in sql
SQL
0 vote361 views2 answers
Insert data mysql with cmd
SQL
2 votes320 views2 answers
How to view created temporary tables in mysql
SQL
0 vote353 views1 answer
Mysql get hour from datetime
SQL
0 vote340 views4 answers
First max salary in sql
SQL
2 votes325 views1 answer
Set boolean flasksql
SQL