On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote:

SELECT * FROM pet WHERE birth >= "1998-1-1";

Try: SELECT * FROM pet WHERE birth >= "1998-01-01";


You need 2 characters for the day and month fields.

     ___/
    /
   __/
  /
 ____/
 Ed Leafe
 http://leafe.com/
 http://opentech.leafe.com


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to