cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

How to Remove T00:00:00Z from DateTime?

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?

LiamMichael
Member
0 REPLIES 0