Display problem
Posted: Mon 26 Nov 2007 21:48
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
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