I connect to a MySQL database with a JDBC driver. In a table, I have a DATE type column with some values like '2008-00-00'.
With MySQL Query Browser the result is '2008-00-00' but with Squirrel (JDBC driver) the result is '2007-11-30'.
Is there any option in the JDBC driver to get the value format like '2008-00-00'. I had a look at http://dev.mysql.com/doc/refman/5.5/en/connector-j-reference-configuration-properties.html
, but couldn't manage to find the right property.
If anyone has already encountered this problem, is there somewhere I can configure this behavior ?
Edited 1 time(s). Last edit at 03/11/2013 10:41AM by Aurelien PANIZZA.