/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 vote284 views1 answer
Find largest table in mysql database
SQL
0 vote292 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
5 votes308 views2 answers
Get number of columns sql
SQL
1 vote299 views1 answer
Tsql find foreign key references
SQL
0 vote313 views1 answer
Print hello world in plsql
SQL
0 vote322 views1 answer
Mysql bash execute sql file
SQL
1 vote324 views1 answer
Set id count mysql
SQL
-1 vote299 views1 answer
Module operator in oracle sql
SQL
2 votes322 views1 answer
Oracle block
SQL
1 vote267 views1 answer
Select random sample sql
SQL