/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 vote308 views1 answer
Load data infile mariadb slow
SQL
1 vote288 views1 answer
Access the postgres psql
SQL
0 vote303 views1 answer
Sql server user permissions and roles
SQL
0 vote280 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
-1 vote276 views1 answer
Export mysql table to file
SQL
13 votes275 views2 answers
Oracle inner join
SQL
0 vote300 views1 answer
How to know if table in rigt or left in sql
SQL
-1 vote314 views3 answers
PS5
SQL
0 vote281 views1 answer
Grepper sql workbench download
SQL
1 vote292 views3 answers
Java.sql.sqlexception: access denied for user
SQL