MySQL Forums
Forum List  »  MySQL Query Browser

Squirrel and MySQL Browser date interpretation
Posted by: Aurelien PANIZZA
Date: March 06, 2013 11:04AM


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.

Options: ReplyQuote

Written By
Squirrel and MySQL Browser date interpretation
March 06, 2013 11:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.