[DB-SIG] pb with Datetime

Dave Cole djc@object-craft.com.au
16 Sep 2002 16:39:32 +1000


>>>>> "Federico" == Federico Di Gregorio <fog@initd.org> writes:

Federico> Il ven, 2002-09-13 alle 09:27, Denis Cartier Millon ha
Federico> scritto:
>> I try to get datetime from sybase with python and a connection
>> ODBC: with the script "select * from Atable" and cursor.execute()
>> (1458, <DateTime object for '2000-12-26 11:04:00.00' at 2148670>,
>> 4, None, 1.0)
>> 
>> why ?

Federico> because the sybase module is well-written and you get a
Federico> usefull mx.DateTime object. (i think :)

You can tell the Sybase module not to return an mxDateTime object for
DATETIME columns (although I can't work out why you would do that).
All you have to do is

import Sybase
Sybase.use_datetime = 0

- Dave

-- 
http://www.object-craft.com.au