I installed version 5 and when I do the following queryselect date_format (current_date, '% Y-% m-% d') as datathe result is (Excluded)Can someone help me?
The only time I have seen "Excluded" was when the result was a LOB.You need to either click on the grid to view the record contents or select Tools/Options/Database/General and click on "Read LOBs when initially fetching data".Linda
I'm not sure how to fix this.I noticed it myself for the first time yesterday but it only occurs in version 5 of Toad for MySQL for me. I just went back to version 4 and the output was fine.In my case I had to use cast/convert to allow the character and integer values to appear in the output without being converted to hex.Linda
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)
SELECT CAST(date_format(current_date, '%Y-%m-%d') AS char) AS data