[This topic is migrated from our old forums. The original author name has been removed]
Hello DbVis team,
DbVisualizer shows the max. allowable DB2 Timestamp of 9999-12-31-24.00.00.000000 as 10000-01-01-00:00:00.000000.
Product: DbVisualizer Pro 9.0
Build: #1900 (2012/11/29 11:43)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_35
Java Vendor: Sun Microsystems Inc.
OS Name: Windows XP
OS Arch: x86
OS Version: 5.1
Timestamp Format set in Tool Properties: yyyy-MM-dd-HH:mm:ss.SSSSSS
DB2 is DB2 10 for z/OS:
IBM Data Server Driver for JDBC and SQLJ
The reason is probably that the hour part of the following is not correct and thus it is rounded up.
9999-12-31-24.00.00.000000 -> 10000-01-01-00:00:00.000000
If you try:
9999-12-31-18.104.22.1689999 -> 9999-12-31-22.214.171.1249999
Does this make sense?