/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 vote172 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
1 vote184 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote169 views1 answer
Postgres check for foreign key
SQL
6 votes174 views2 answers
Mysql execute file
SQL
2 votes180 views2 answers
Postgres add column integer
SQL
3 votes196 views2 answers
Mysql select database
SQL
0 vote233 views1 answer
Fetching data from mysqldb
SQL
0 vote168 views1 answer
Add sqlite3 in lumen
SQL
7 votes188 views1 answer
Return insert results in POSTGRESQL
SQL
1 vote169 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL