[Zope-DB] Formatting DateTime values

M.-A. Lemburg mal@lemburg.com
Thu, 18 Jul 2002 19:00:06 +0200

Is there a way to control formatting DateTime values in SQL
queries ?

We are having problems with (Zope) DateTime values being formatted
via their __str__ method in the Zope DA.py code. Since Zope's
DateTime implementation uses a completely non-standard format
(rather than ISO), several databases choke on queries which
include these as parameters or -even worse- interpret the
values differently.

Marc-Andre Lemburg
CEO eGenix.com Software GmbH
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/