/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

2 votes189 views1 answer
Username sql
SQL
0 vote198 views1 answer
Show mysql account privilleges
SQL
5 votes143 views1 answer
Sysdate in oracle sql
SQL
0 vote148 views1 answer
Python connect microsoft sql server
SQL
12 votes143 views2 answers
Select into insert sql server
SQL
0 vote146 views2 answers
How to use aggregate functions in sql
SQL
3 votes146 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
0 vote183 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
0 vote154 views1 answer
T-SQL - Where Used List (Table/View)
SQL
8 votes177 views1 answer
Racle create auto increment column
SQL