/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 vote104 views1 answer
Update top 100 order by sql server
SQL
0 vote239 views1 answer
Sql datum formatieren
SQL
8 votes94 views1 answer
How to remove tables from postgresql
SQL
0 vote95 views1 answer
Select all tables linked server sql
SQL
0 vote114 views1 answer
Sql filter rows with condition
SQL
0 vote111 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote582 views1 answer
Sql show table name in result
SQL
0 vote93 views1 answer
Set column width in sqlplus
SQL
0 vote146 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote107 views1 answer
Migration graphql
SQL