MySQL Forums
Forum List  »  Connector/J, JDBC and Java

Advanced Search
New Topic

JDBC and date translation
Posted by: Aurelien PANIZZA
Date: March 11, 2013 10:36AM

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
JDBC and date translation
Aurelien PANIZZA
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.