/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 vote325 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
1 vote336 views1 answer
Oracle create as select
SQL
1 vote393 views1 answer
Postgresql float 2 decimal places
SQL
65 votes559 views6 answers
Sql add column to table
SQL
1 vote323 views2 answers
Sql convert datetime to year month
SQL
0 vote349 views1 answer
Mysql error 1452
SQL
0 vote350 views1 answer
How change the field place in mysql
SQL
0 vote419 views1 answer
Scheduled mysql database backup in linux
SQL
22 votes328 views3 answers
Sql cheat sheet
SQL
0 vote341 views1 answer
Sql insert from excel
SQL