Date_Format column output is suddenly in Hex

6 posts
[expired user #5244]'s profile image [expired user #5244] posted 13 years ago in Running SQL scripts Permalink
Since one of the night builds some days ago the result of select date_format(`DateColumn`, '%Y-%m-%d') as 'date' ....
where DateColumn is of DATETIME Type is shown as a Hex value e.g. "0x323031302D31302D3031" instead of the expected "2010-10-01"
NB: the wrong result is shown when connected to a MySQL 3.23.58, it works on an MySQL 5.1.50

Can you please fix this issue?

Please login to leave a reply, or register at first.