IRC log for #storm on 20100425

07:52.48midgetspyhm, I have a date column and want to do a query for rows with a certain year in that column
07:53.37midgetspysince 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.14midgetspyis there any way to do this without doing dateColumn >= datetime.date(2010, 01, 01), dateColumn <= datetime.date(2010, 12, 31)?
10:59.18jkakarmidgetspy: 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)

Generated by irclog2html.pl Modified by Tim Riker to work with infobot.