/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

6 votes197 views1 answer
Phpmyadmin reset root password
SQL
0 vote206 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote238 views1 answer
Show all sequences postgres
SQL
0 vote191 views1 answer
Oracle locked objects
SQL
1 vote197 views1 answer
How to install mysql 8.0 windows service
SQL
23 votes220 views6 answers
Create table sql server
SQL
0 vote202 views1 answer
Calculate age in sql
SQL
-1 vote231 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote210 views1 answer
Get date ISO in psql
SQL
0 vote257 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL