/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 vote166 views1 answer
Update top 100 order by sql server
SQL
1 vote120 views1 answer
Unique vs distinct sql
SQL
0 vote144 views1 answer
Tsql generate rows
SQL
0 vote154 views1 answer
How to make case insensitive in sql
SQL
0 vote160 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote147 views1 answer
Syntax for changing column size in mysql
SQL
1 vote193 views1 answer
Sql server if exists update else insert
SQL
1 vote181 views1 answer
Limit offset order by mysql
SQL
11 votes161 views3 answers
Python sqlite3 create table if not exists
SQL
3 votes144 views1 answer
Start mysql server linux terminal
SQL