JDBC and date translation
Hi all,
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 ?
Regards
Edited 1 time(s). Last edit at 03/11/2013 10:41AM by Aurelien PANIZZA.
Subject
Written By
Posted
JDBC and date translation
March 11, 2013 10:36AM
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.