How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

DbVis 9.0: DB2 Timestamp 10000-01-01-00:00:00.000000 > DB2 limit

[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: DB2 DSN10015 IBM Data Server Driver for JDBC and SQLJ 4.13.127 Regards D.
1 Comment
[This reply is migrated from our old forums.]

Re: DbVis 9.0: DB2 Timestamp 10000-01-01-00:00:00.000000 > DB2 limit
Hi, 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-23.59.59.999999 -> 9999-12-31-23.59.59.999999 Does this make sense? Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics