MySQL Forums
Forum List  »  Connector/JDBC and Java

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

Written By
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.