Truncated timestamp values in query results and table data¶

When query results or table data in the catalog navigation view include a timestamp column, and a timestamp ends in one or more zeros (0), the zeros are not included in the output.

To correct this issue, add the timestampPrecisionReporting =2 JDBC property to your database connection:

For more information about this property, see Common IBM Data Server Driver for JDBC and SQLJ properties for all supported database products.