Breaking News: Grepper is joining You.com. Read the official announcement!

mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

Powerful Petrel answered on November 21, 2021 Popularity 1/10 Helpfulness 1/10

answer mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z

Comment

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');

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: datetime import mysql sql

Link to this answer
Share Copy Link