Here is info I printed from fetched row for dates (in smalldatetime column):
*** edates ['Dec 12 2006 9:01AM', 'Dec 12 2006 9:08AM', 'Jan 28 2009 12:00AM']
*** edate Dec 12 2006 9:01AM
*** type(edate) <type 'DateTimeType'>
*** edate.year 2006
*** edate.month 11
*** edate Dec 12 2006 9:08AM
*** type(edate) <type 'DateTimeType'>
*** edate.year 2006
*** edate.month 11
*** edate Jan 28 2009 12:00AM
*** type(edate) <type 'DateTimeType'>
*** edate.year 2009
*** edate.month 0
As you can see the month is zero-based (Dec is represented as 11) which is strange given that everything else uses 1 for Jan, etc (in Sybase, mxDateTime, etc)
I was hoping for either a datetime object or something I can use to create one (without having to fix anything).