[Squirrel-sql-users] select max(date) not displaying in date format

[Dan C. <dc...@ke...>]

Why do I sometimes get the results of a simple max() on a datetime field
displayed as binary?=20

=20

select category, max(create_date)

from sometable, anothertable

where sometable.id =3D anothertable.id

group by category

=20

I date results I get look like a series of bytes rather than formatted =
as a
date. e.g

category create_date

aaa         32  30  30  34  2d  31  31  2d  30  31  20  30  30  3a  30  =
30
3a  30  30 =20

bbb        =20

=20

SquirreL reports on the metadata tab that the column type for the
max(create_date) field is -3 VARBINARY

=20

The field is mysql type datetime. This is using Squirrel 2.2 with the =
latest
mysql jdbc driver. I've seen a similar issue  with some Oracle queries.

=20

Is there some setting in squirrel or the jdbc driver that can help =
control
this? Can I write the query in a different way to force it to be a date
field as a result?

=20

Thanks.

Dan