MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT STR_TO_DATE('14/11/2018 20:10:04 +00:00', '%d/%m/%Y')

STR_TO_DATE('14/11/2018 20:10:04 +00:00', '%d/%m/%Y')

2018-11-14

SHOW WARNINGS

Level
Code
Message

Warning
1292
Truncated incorrect date value: '14/11/2018 20:10:04 +00:00'

SELECT STR_TO_DATE(LEFT('14/11/2018 20:10:04 +00:00', 10), '%d/%m/%Y')

STR_TO_DATE(LEFT('14/11/2018 20:10:04 +00:00', 10), '%d/%m/%Y')

2018-11-14

SHOW WARNINGS
CREATE TABLE big_data (date varchar(30))
INSERT INTO big_data VALUES
('14/11/2018 20:10:04 +00:00')
ALTER TABLE big_data ADD
realdate DATE
UPDATE big_data SET realdate = STR_TO_DATE(left(date, 10), '%d/%m/%Y');
SELECT * FROM big_data

date
realdate

14/11/2018 20:10:04 +00:00
2018-11-14

ALTER TABLE big_data DROP realdate
ALTER TABLE big_data ADD
realdate DATE AS (STR_TO_DATE(date, '%d/%m/%Y'))
SELECT * FROM big_data

date
realdate

14/11/2018 20:10:04 +00:00
2018-11-14