[Zope] Date Problem of ODBC DA

Jay, Dylan djay@lucent.com
Thu, 3 Jun 1999 10:21:04 +1000


>Date: Wed, 02 Jun 1999 16:17:32 +0800
>From: "T. C. Huang" <a00tch00@nchc.gov.tw>
>To: zope@zope.org, mj@antraciet.nl
>Subject: [Zope] Date Problem of ODBC DA

>Hi,
>   I access the data in Oracle 7.3(AIX server) through ODBC DA on NT
>platform. Things work well unitl the table has column with DATE type.
>When my SQL method is "select start_date from project_table", and test
>it in Zope 1.10.2, I get only "Sorry, an error occurred.".
>   Is it a problem of  Zope or ODBC DA? How to fix it?
>
>T. C. Huang

Your problem is with the implimentation of DateTime. It doesn't support the
timezone your in properly. You will need to discover  the text label for the
timezone that python is reporting to DateTime and put something like this in
the DateTime class.
    _zmap={'aest':'GMT+1000', 'aedt':'GMT+1100', 'aus eastern standard
time':'GMT+1000',

The datetime code should be changed to find the current timezone as its
offset rather than its text label. This way this problem would never
happen!!!