Message1874

Author r_walter
Recipients
Date 2007-08-27.19:31:30
SpamBayes Score
Marked as misclassified
Message-id
In-reply-to
Content
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.
History
Date User Action Args
2008-02-20 17:18:00adminlinkissue1782856 messages
2008-02-20 17:18:00admincreate