Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread John Machin
On Jun 3, 4:47 am, Tim Golden <[EMAIL PROTECTED]> wrote: > Steve Holden wrote: > > YuePing Lu wrote: > >> Hello, > > >> Has any of you ever used Python odbc to retrieve data from a relational DB? > > >> I encountered a problem where it can't handle datetime _earlier than > >> _*1969*, and _later th

Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread Tim Golden
Steve Holden wrote: > YuePing Lu wrote: >> Hello, >> >> Has any of you ever used Python odbc to retrieve data from a relational DB? >> >> I encountered a problem where it can't handle datetime _earlier than >> _*1969*, and _later than _*2040*. It just returned some garbage strings >> when I call

Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread Steve Holden
YuePing Lu wrote: > Hello, > > Has any of you ever used Python odbc to retrieve data from a relational DB? > > I encountered a problem where it can't handle datetime _earlier than > _*1969*, and _later than _*2040*. It just returned some garbage strings > when I call str(my_date_object). > > W

Python 2.3 ODBC Datetime limitations

2007-06-01 Thread YuePing Lu
Hello, Has any of you ever used Python odbc to retrieve data from a relational DB? I encountered a problem where it can't handle datetime *earlier than **1969*, and *later than **2040*. It just returned some garbage strings when I call str(my_date_object). When I call strptime to convert the va