No!! NULL = NULL returns NULL You must execute: SELECT CUSTOMER WHERE bdate IS NULL Ignatius ____________________________________________ ----- Original Message ----- From: <Jeffrey_N_Dyke@Keane.com> To: "buttoz" <buttoz@012.net.il> Cc: <php-db@lists.php.net> Sent: Wednesday, April 30, 2003 11:11 PM Subject: 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: 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 > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
