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!!!