distal-attribute
distal-attribute
distal-attribute
distal-attribute

Date_Format column output is suddenly in Hex

User, date Message
Written by rlaudens
3 years ago
Category: Running SQL scripts
6 posts since Wed, 27 Oct 10
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.