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

[Robert M. <rob...@gm...>]

On 7/10/06, Dan Climan <dc...@ke...> wrote:

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

Variable length binary data, Huh?.  Sounds like a driver issue.  When
I create a
datetime in MySQL 4.1.14 SQuirreL reports it's type to be 93 (TIMESTAMP).
What was the DDL statement used to create the table? I simply used:

create table test  (
    mytime datetime
)

and the following for the data :

insert into test values (current_timestamp)

It shows a correctly formatted datetime in the contents tab and SQL results tab.

>
> 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.

If the driver reports the field as binary, I don't know how SQuirreL
could tell that
it should be formatted as a date.  I'd file a bug report with the
driver vendor if it
happens consistently.

Rob