Squirrel and MySQL Browser date interpretation

[Aurelien PANIZZA]

Hi,

I've got a MySQL (5.0) database. There is a table with column DATE. In this field, many data (maybe all) have a wrong date format. When the data's are inserted, the date format provided is 'yyyy' (only the year). So, MySQL convert the data like : '2008-00-00' if the number '2008' was inserted.

When retrieving the date with SQL Browser, it will be display like '2008-00-00'. But when retrieving the date with Squirrel, it's displayed like '2007-11-30'. The result we want is the one displayed by MySQL Browser ('2008-00-00') but our clients use Squirrel.

Is there any option in Squirrel to get the result like the way MySQL Browser does ?

I know the application is quite ugly but, unfortunately change it, is not in the TODO list.

Thank you.