CREATE TRIGGER tr
BEFORE INSERT
ON test
FOR EACH ROW
SET NEW.Date_VARCHAR = STR_TO_DATE(NEW.Date_VARCHAR, '%Y-%m-%dT%h-%i-%s');
✓
hidden batch(es)
INSERT INTO test (`Date_VARCHAR`)
VALUES('2021-05-10T08-45-30'), ('2021-05-10T08-46-30'), ('2021-05-10T08-47-30'), ('2021-05-10T08-48-30');
SELECT * FROM test;
