/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

1 vote203 views1 answer
Epoch time converter in snowflake
SQL
0 vote169 views1 answer
Clone table structure mysql
SQL
0 vote194 views1 answer
Sql server system messeges
SQL
0 vote205 views1 answer
Postgres regex word boundary
SQL
0 vote192 views1 answer
Postgresql show owner of database
SQL
0 vote201 views3 answers
Postgresql allow remote connections
SQL
1 vote182 views1 answer
How to see all table partition in oracle
SQL
8 votes212 views3 answers
Connect python to mysql
SQL
0 vote198 views1 answer
Lost connection to mysql
SQL
0 vote182 views1 answer
Postgres float to int
SQL