Re: date field is empty ?

[Jeffrey_N_Dyke@Keane.com]

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