List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2002 11:23pm
Subject:Re: now() & dates
View as plain text  
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

Thread
now() & datesSandeep Murphy9 May
  • Re: now() & datesPaul DuBois11 May
    • Re: now() & datesNeil Zanella13 May