[Zope] Date problems with ODBC persist in Zope 2

Alexander Staubo alex@mop.no
Tue, 28 Sep 1999 18:12:27 +0200


Wasn't this fixed long ago in a galaxy far, far away? Somebody kindly
posted DateTime.py patches (for handling "foreign" time zones) for Zope
1.x at one point, and I blatantly assumed they had been rolled into Zope
2, but apparently not? 

Using Zope 2.0.1 and the latest ODBC DA (ZODBCDA-3-0-3) with MS SQL
Server 6.5, I'm getting tracebacks like this one:

Error Type: ValueError
Error Value: Invalid value, 1999-09-23 16:17:16.147, for time in record
0

Traceback (innermost last):
  File C:\zope\intra\lib\python\ZPublisher\Publish.py, line 214, in
publish_module
  File C:\zope\intra\lib\python\ZPublisher\Publish.py, line 179, in
publish
  File C:\zope\intra\lib\python\Zope\__init__.py, line 201, in
zpublisher_exception_hook
    (Object: ElementWithAttributes)
  File C:\zope\intra\lib\python\ZPublisher\Publish.py, line 165, in
publish
  File C:\zope\intra\lib\python\ZPublisher\mapply.py, line 160, in
mapply
    (Object: index_html)
  File C:\zope\intra\lib\python\ZPublisher\Publish.py, line 102, in
call_object
    (Object: index_html)
  File C:\zope\intra\lib\python\OFS\DTMLDocument.py, line 166, in
__call__
    (Object: index_html)
  File C:\zope\intra\lib\python\DocumentTemplate\DT_String.py, line 502,
in __call__
    (Object: index_html)
  File C:\zope\intra\lib\python\DocumentTemplate\DT_In.py, line 672, in
renderwob
    (Object: FindMedia)
  File C:\zope\intra\lib\python\Shared\DC\ZRDB\RDB.py, line 272, in
__getitem__
ValueError: (see above)

-- 
Alexander Staubo             http://www.mop.no/~alex/
"He could open a tin of sardines with his teeth, strike a Swan
Vestas on his chin, rope steers, drive a steam locomotive and hum
all the works of Gilbert and Sullivan without becoming confused or
breaking down in tears."
--Robert Rankin, _The Book of Ultimate Truths_