[Dbix-class] using a function

[J. Shirley]

On 6/8/07, Octavian Rasnita <orasnita at gmail.com> wrote:
>
> Hi,
>
> Please tell me how to do the following SQL clause, or tell me where to
> read
> how to do it. I have searched in some POD docs from SQL:: and DBIx::, but
> I
> couldn't find the answer.
>
> ... where date(date_field)=3D'2007-06-08';
>
> Thank you.
>
> Octavian
>
>
>
This will work just fine:
->search( { 'DATE(date_field)' =3D> '2007-06-08 } );

-- =

J. Shirley :: jshirley at gmail.com :: Killing two stones with one bird...
http://www.toeat.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20070608/a47=
b6a4f/attachment.htm