https://community.developer.cybersource.com/t5/Integration-and-Testing/How-to-Remove-T00-00-00Z-from-DateTime/m-p/73922#M45854 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I'm new to MySQL. I am using MySQL 5.6.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I have inserted values of DateTime data with DATE_FORMAT(date_add('2020-07-01', interval hours.hour hour).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">However, the data is coming out like this: 2020-07-01T00:00:00Z.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Tried to force it by DATE_FORMAT(date, '%Y-%m-%d %H:%i:%s) but did not work.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Does anyone know how I can remove the 'T' and 'Z' from the DateTime data?</P> Mon, 09 Nov 2020 12:47:23 GMT LiamMichael 2020-11-09T12:47:23Z https://community.developer.cybersource.com/t5/Integration-and-Testing/How-to-Remove-T00-00-00Z-from-DateTime/m-p/73922#M45854 <P class="_1qeIAgB0cPwnLhDF9XSiJM">I'm new to MySQL. I am using MySQL 5.6.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">I have inserted values of DateTime data with DATE_FORMAT(date_add('2020-07-01', interval hours.hour hour).</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">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.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">However, the data is coming out like this: 2020-07-01T00:00:00Z.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Tried to force it by DATE_FORMAT(date, '%Y-%m-%d %H:%i:%s) but did not work.</P><P class="_1qeIAgB0cPwnLhDF9XSiJM">Does anyone know how I can remove the 'T' and 'Z' from the DateTime data?</P> Mon, 09 Nov 2020 12:47:23 GMT https://community.developer.cybersource.com/t5/Integration-and-Testing/How-to-Remove-T00-00-00Z-from-DateTime/m-p/73922#M45854 LiamMichael 2020-11-09T12:47:23Z