/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

0 vote150 views1 answer
Sql_inner_join
SQL
28 votes125 views6 answers
Sql update
SQL
0 vote140 views3 answers
Mysqli count down
SQL
0 vote136 views2 answers
How to drop mili second in sql
SQL
0 vote125 views1 answer
Oracle list proxy users
SQL
0 vote131 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote129 views1 answer
Select last N rows mysql
SQL
1 vote139 views2 answers
Sql now - 1 day
SQL
4 votes138 views1 answer
Oracle nls_date_format
SQL
0 vote128 views1 answer
Import mysql'
SQL