I'm new to MySQL. I am using MySQL 5.6.
I have inserted values of DateTime data with DATE_FORMAT(date_add('2020-07-01', interval hours.hour hour).
Hours.hour is just a table with hours 0 - 23 that I am using to populate the database with every hour for a specific date.
However, the data is coming out like this: 2020-07-01T00:00:00Z.
Tried to force it by DATE_FORMAT(date, '%Y-%m-%d %H:%i:%s) but did not work.
Does anyone know how I can remove the 'T' and 'Z' from the DateTime data?
