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. |
|
Date |
User |
Action |
Args |
2008-02-20 17:18:00 | admin | link | issue1782856 messages |
2008-02-20 17:18:00 | admin | create | |
|