Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does the Toolbox JDBC driver deal with dates before 1940 (or after 2039)?

April 26, 2017dates deal driver JDBC Toolbox

0

Posted

How does the Toolbox JDBC driver deal with dates before 1940 (or after 2039)?

1 Answer

0

Posted

The IBM i database supports several date formats. The Toolbox JDBC driver uses the date format that is set up as the default on the IBM i system. This default is usually set to “mdy” which only supports dates between 1940 and 2039. You can override the date format by specifying the “date format” property when opening the JDBC connection. The best choice is “iso”, which supports a full four-digit date. The easiest way to do this is to add “;date format=iso” to the end of the URL used when connecting to the database.