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, 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.

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.