Menu

#37 DateTimeType month 0-based

open
nobody
None
5
2011-10-13
2011-10-13
Anonymous
No

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).

Discussion


Log in to post a comment.