Re: date field is empty ?

you'll only get a match on that if you have defined the field specifically as a date field, and not a datetime field, which you may have done. did you allow the field to be NULL? if so you'll have to check "SELECT CUSTOMER WHERE bdate = NULL"; an empty datetime field would be "0000-00-00 00:00:00", unless you set empty values to be NULL. hth Jeff "buttoz" <buttoz@012.ne To: php-db@lists.php.net t.il> cc: Subject: [PHP-DB] date field is empty ? 04/30/2003 03:51 PM hi, how can check in select command if bdate field is empty. i try SELECT CUSTOMER WHERE bdate='0000-00-00'; that's not success . i am sure i have record without value in bdate field thanks zuhear -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php