[SQLObject] How do I use a postgreSQL function like date_part?

2008-09-03 Thread Matthew Wilson
I want to do a select like this with SQLObject: select * from people where date_part('day', createddate) = date '2008-09-01'; That query should choose people created any time on September 1st. In SQLObject, this is what I'm doing: People.select("date_part('day', createddate) = date

Re: [SQLObject] How do I use a postgreSQL function like date_part?

2008-09-03 Thread Oleg Broytmann
On Wed, Sep 03, 2008 at 01:43:54PM +, Matthew Wilson wrote: > I want to do a select like this with SQLObject: > > select * from people > where date_part('day', createddate) = date '2008-09-01'; > > That query should choose people created any time on September 1st. > > In SQLObject,