/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 vote258 views1 answer
Concat column value of same user in mysql
SQL
0 vote254 views1 answer
Replace null value within column mysql
SQL
0 vote253 views1 answer
Mysql function variable
SQL
2 votes257 views2 answers
How to get capital letter first in sql
SQL
0 vote286 views1 answer
How to find total working hour in sql
SQL
3 votes259 views1 answer
Sql replace character in string in all records
SQL
0 vote253 views1 answer
Sql orcale i forgot what my name & password was
SQL
-2 votes290 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote291 views3 answers
Call to undefined function mysql_connect()
SQL
1 vote259 views1 answer
Oracle update with sequence
SQL