Re: Database Date/Time Functions?

2009-08-19 Thread Dr. Loboto
Bar.created' >= (NOW() - interval '7 days')" > ) > > On Aug 19, 6:23 am, Elmo wrote: > > > > > I would like to use the built in database date/time functions as part > > of a 'conditions'. How is this done? > > > i.e.: sel

Re: Database Date/Time Functions?

2009-08-19 Thread rich...@home
or... 'conditions'=>array( "Bar.created' >= (NOW() - interval '7 days')" ) On Aug 19, 6:23 am, Elmo wrote: > I would like to use the built in database date/time functions as part > of a 'conditions'. How is this done? > >

Re: Database Date/Time Functions?

2009-08-19 Thread majna
move sql operator to the left: conditions'=>array('Bar.created >=' => "(NOW() - interval '7 days')") On Aug 19, 7:23 am, Elmo wrote: > I would like to use the built in database date/time functions as part > of a 'conditions'. H

Database Date/Time Functions?

2009-08-18 Thread Elmo
I would like to use the built in database date/time functions as part of a 'conditions'. How is this done? i.e.: select foo from bar where created >= (NOW() - interval '7 days'); I tried: 'conditions'=>array('Bar.created' =&