/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

6 votes129 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote113 views1 answer
Woocommerce mysql price table
SQL
0 vote111 views1 answer
Sql server isnull function nor working count
SQL
-1 vote82 views1 answer
Mysql if example
SQL
0 vote128 views1 answer
Ignore case in string sql
SQL
0 vote62 views1 answer
Mysqli or pdo
SQL
0 vote104 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
1 vote98 views2 answers
Mysql SELECT
SQL
0 vote112 views1 answer
Mysql page segment
SQL
0 vote115 views1 answer
How to check event scheduler status mysql
SQL