Olli Wang wrote: > i have a column which type is DateTimeCol > and i add a record for example: > > import datetime > Table(date=datetime.datetime(2005,12,3)) > Table(date=datetime.datetime(2005,12,10)) > > now i want to select the record where year=2005 and month=12 > how could i create a query?
What ways did you try? This should work (untested): Table.select(AND(Table.q.date >= datetime.datetime(2005, 12, 1), Table.q.date < datetime.datetime(2006, 1, 1)))
