Skip navigation links

MySQL Forums :: Connector/JDBC and Java :: JDBC and date translation


Advanced Search

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.

Options: ReplyQuote


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