/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

7 votes329 views1 answer
Grant schema permissions postgres
SQL
0 vote337 views1 answer
How to check which sp is running in sql server
SQL
5 votes348 views1 answer
Ascending order and where in sql
SQL
3 votes347 views1 answer
Oracle user quota on tablespace
SQL
0 vote346 views1 answer
Python mysql executemany
SQL
0 vote334 views2 answers
Mysql multiply
SQL
0 vote389 views1 answer
How to retrive the today date sql
SQL
0 vote379 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
6 votes368 views1 answer
Oracle pl sql source
SQL
1 vote389 views1 answer
Mysql text to decimal
SQL