You can use Criteria's custom parameter like so:
$c = new Criteria();
$c->add(RecordPeer::DATE, "MONTH(" . RecoredPeer::DATE .") = '".
$month ."'", Criteria::CUSTOM);
Regards,
Jamie Learmonth
Boxlight Media Ltd.
On 20 Ago, 00:47, Hoaxz <[EMAIL PROTECTED]> wrote:
> BTW I;ll like to get a Propel wise solution...
>
> On Aug 19, 3:45 pm, Hoaxz <[EMAIL PROTECTED]> wrote:
>
>
>
> > Hey every one.
>
> > My problem is simple to understand but I can't find an answerd. I want
> > to filter records by month, meaning that if in my APP the user ask for
> > record with Month 01 (January), the search will return exaclty those
> > records, but I can't find a way to compare the month on a DATE field
> > with the month given.
>
> > PseudoCode would be something like
>
> > SELECT * FROM record WHERE MONTH(record.date) = $month
>
> > Any help or orientation may help.
>
> > Thanks
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
