/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 vote257 views1 answer
Implicit inner join table alias with id values
SQL
9 votes300 views3 answers
Pyodbc connect to sql server
SQL
0 vote277 views2 answers
Sqlalchemy core in clause
SQL
4 votes251 views1 answer
Oracle show error line number
SQL
9 votes285 views2 answers
Convert data type in sql
SQL
2 votes299 views1 answer
Q operator in oracle
SQL
1 vote265 views2 answers
Mysql join two tables
SQL
1 vote276 views1 answer
Join to find results not in another table
SQL
0 vote260 views2 answers
Cascade syntax in sql
SQL
0 vote279 views1 answer
Postgres type equivalent to timespan c#
SQL