/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

13 votes352 views2 answers
Get tables in database sql
SQL
0 vote364 views1 answer
View t-sql mail configuration
SQL
0 vote374 views2 answers
Generate sql trigger through ef migration
SQL
5 votes363 views3 answers
Mysql remove unique constraint
SQL
3 votes351 views1 answer
Sql server version query
SQL
5 votes356 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote344 views1 answer
Simple project for database
SQL
0 vote357 views1 answer
Proc sql not in working
SQL
5 votes400 views1 answer
Mysql count lines
SQL
10 votes339 views6 answers
Between sql
SQL