/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

27 votes349 views3 answers
Mysql show tables in database
SQL
0 vote317 views1 answer
Remove default constraint sql server
SQL
0 vote316 views1 answer
Flask sqlalchemy update row
SQL
0 vote350 views1 answer
View psql output in horizontal scrolling
SQL
0 vote296 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
1 vote334 views1 answer
Sql server kill all connections
SQL
-2 votes327 views1 answer
Group functions in sql
SQL
1 vote355 views3 answers
Alter schema sql server
SQL
0 vote349 views1 answer
Set column in all row mysql
SQL
1 vote313 views2 answers
Sql convert datetime to year month
SQL