Squirrel and MySQL Browser date interpretation
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.
Subject
Written By
Posted
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.