Linda Thanks for your response. I tried your answer but the information I get is 0x323031302D31312D3032 ... If you click on the result I can see it in Hex, ASCII and UTF-8. You know how to get the result directly in ASCII and UTF-8?
Don't quote me on this, but at some point when I had upgraded mysql my dates started coming across as byte's in java that I would have to convert back to ascii, maybe you are having the same issue here?
Try giving the result a CAST to char like this following example... (it worked on my system)
SELECTCAST(date_format(current_date, '%Y-%m-%d') ASchar) AS data