/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 vote368 views2 answers
Collation in sql
SQL
6 votes365 views3 answers
Date_trunc postgres
SQL
0 vote381 views1 answer
Ms sql filter all sympbol
SQL
1 vote367 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote380 views1 answer
Sql last 3 rows
SQL
0 vote378 views1 answer
Sql quary stuf
SQL
0 vote365 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote365 views1 answer
Mysqlcli how to load external sql file
SQL
1 vote392 views1 answer
Postgresql substring last
SQL
5 votes351 views1 answer
Oracle columns in all_tables
SQL