'MySQL DATE_FORMAT from '1970-01-01T00:00:00Z' to '1970-01-01 00:00:00' [duplicate]

Hello I have a MySQL query like:

UPDATE Table_name SET Value= DATE_FORMAT(Date, '%d-%m-%Y %H:%i:%s') WHERE id = 3

It results in an error message "message": "Data truncation: Truncated incorrect datetime value: '1970-01-01T00:00:00Z'"

Is there a way to transform Date to '1970-01-01 00:00:00'? Without the T and Z

Best regards

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source