Try 'Post.added' => " > -!CURRENT_DATE"
or 'Post.added' => " > -!SYS_DATE" The "-!" symbol tells cake 1.2 to not try to parse the oracle function in the condition as a string. Raphael Spindell http://www.webspin.biz On Jan 22, 10:45 pm, Chris <[EMAIL PROTECTED]> wrote: > I am using CakePHP 1.2 and Oracle. > > I am trying to figure out how to tell the find function in a > controller that a field in the condition statement is something other > than a string. > > I am trying to do a comparison on a datetime field in the Oracle db. > > so I have: > > <code> > $this->ControllerName->findAll( > array( > 'Post.added' => ' > ' . date('m/d/Y H:i:s') > ) > ); > </code> > > However, I don't want it to do the comparison against this format, I > want it to use the Oracle format. Of course I could just format this > in the correct format, but lets say that I can't. > > I'm sure there is an easy way to do this. I looked in the > dbo_oracle.php and see a function value() and see a date type in > there, but can't figure out how to set that. > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
