/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 vote145 views1 answer
Mysql default tls v1.3 ciphersuites
SQL
1 vote123 views1 answer
Sql server 2012 query history
SQL
4 votes82 views1 answer
Generate class from sql table c#
SQL
0 vote199 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote126 views2 answers
How to set global time_zone in mysql
SQL
8 votes126 views3 answers
Postgresql connection string c#
SQL
0 vote131 views1 answer
Low level operator in dbms
SQL
0 vote124 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
33 votes122 views2 answers
Postgres how to add field created at
SQL
0 vote136 views1 answer
Nvl2 syntax
SQL