Tuesday, November 13, 2007

IBM Toolbox for Java JDBC properties

AS400 toolbox connection properties

All date values are stored by DB2 in the same internal format regardless of the DATFMT that is specified on the column or field definition. When that data is read from the SQL Table it will be converted to the output date format specified by the application -- in your case the *USA format.

You can add property “date format” to JDBC connection so that the output will be in your desired format:
jdbc:as400://192.168.0.170;translate binary=true; libraries=; date format=iso

Reference:
IBM Toolbox for Java JDBC properties.

0 Comments:

Post a Comment

<< Home