Message1874

The handling of Timestamp in zxJDBC seems not to be correct. Do this on the command-line:

Jython 2.2 on java1.6.0_02
Type "copyright", "credits" or "license" for more information.
>>> from com.ziclix.python.sql import zxJDBC
>>> timestamp=zxJDBC.Timestamp(2007, 8, 24, 14, 10, 0)
>>> print timestamp
2007-08-25 02:10:00.0

But print timestamp should yield 2007-08-24 14:10:00.0.

Solutin seems to be to replace Calendar.HOUR with Calendar.HOUR_OF_DAY in com.ziclix.python.sql.JavaDateFactory. This worked for me, using it for real queries.