/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 vote176 views1 answer
Set Mamp mysql globally
SQL
6 votes146 views1 answer
What is where clause in sql
SQL
3 votes155 views1 answer
Oracle user privileges
SQL
-2 votes158 views2 answers
Union all in sql
SQL
0 vote163 views1 answer
Postgresql inline table
SQL
0 vote144 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote147 views2 answers
Postgresql get last day of month
SQL
0 vote161 views1 answer
Dataframe lambda elif
SQL
0 vote134 views2 answers
Postgresql create role
SQL
0 vote145 views2 answers
What is the library that should import to use all functional database features in SQLite?
SQL