/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 vote111 views7 answers
10 random questions use python and SQL
SQL
9 votes138 views3 answers
Pyodbc connect to sql server
SQL
0 vote110 views1 answer
Regex any word except sql
SQL
2 votes149 views1 answer
Creating a view SQL
SQL
4 votes106 views1 answer
Datepart postgres
SQL
0 vote130 views1 answer
Get created time of database psql 8
SQL
1 vote126 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote113 views1 answer
We are intrested to work with your organization
SQL
13 votes100 views6 answers
Mysql update from select
SQL
7 votes102 views3 answers
Add primary key to database sql
SQL