/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 vote117 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
22 votes114 views3 answers
Join three tables sql
SQL
0 vote122 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote117 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
6 votes123 views2 answers
Can't connect to local mysql server through socket
SQL
3 votes126 views1 answer
Unsigned int in mysql
SQL
0 vote76 views2 answers
Postgresql could not start server mac
SQL
24 votes117 views4 answers
Mssql get all table names
SQL
0 vote118 views2 answers
Script all indexes in a database
SQL
0 vote122 views1 answer
Oracle archivemode
SQL