Re: now() & dates

[Paul DuBois]

At 12:06 +0100 5/9/02, Sandeep Murphy wrote:
>Hi,
>
>What appears to be the problem with the fwg query:
>
>select code,date from multimedia_header where rubrica=87 and  now() >
>'08-03-2002 13:10:53' and date IS NOT NULL
>
>The records returned includes those earlier than 08-03-2002 13:10:53  too..

Dates in MySQL are in CCYY-MM-DD format, not MM-DD-CCYY.

>
>pl help.. thnx in adv,
>
>sands