07:52.48 | midgetspy | hm, I have a date column and want to do a query for rows with a certain year in that column |
07:53.37 | midgetspy | since they're stored 2010-04-25 in the DB I tried dateColumn.like('2010-%') but it didn't like me using a string... so I tried dateColumn.year == 2010 but that doesn't work either |
07:54.14 | midgetspy | is there any way to do this without doing dateColumn >= datetime.date(2010, 01, 01), dateColumn <= datetime.date(2010, 12, 31)? |
10:59.18 | jkakar | midgetspy: The last thing you posted is the way to do it. |
16:39.53 | *** join/#storm shaunm (~shaunm@c-98-212-133-244.hsd1.il.comcast.net) |
17:26.28 | *** join/#storm elmom_ (~elmom@hoasnet-fe29dd00-137.dhcp.inet.fi) |