I have a query that has the following line in the select command :
DATE_FORMAT(stk_trans_date,'%Y-%m') AS `Mnth`
When it is display in the data window, it is shown as a BLOB or BINARY field. When I use the Large object viewer to look at the result it is correct (ie: 2007-10) It even sorts and groups on this calculated field correctly.
Whe I cut and paste into MySQL Query Browser it works fine.
Is this fixed in v2.10.74 ?
Thanks in advance for your help.
slobbering_dog
Display problem
-
- Posts: 4
- Joined: Thu 06 Sep 2007 05:36
- Location: Adelaide, Australia