Null date in MySQL

[kahodges]

I have the following code:

$sql .=" where ( `date` is null or trim(`date`) = '' ) ";

 

I'm using MySQL date format, which is 0000-00-00. When the field is left blank, it leaves 0000-00-00 instead of null. Is there another way around this? If there's an entry in that field instead of null, it causes my php script to not display an entry on the screen.

 

Thanks.

[JonnoTheDev]

When inserting records and there is no date you should set the field to null, otherwise you end up with 0000-00-00

SET date=NULL

 

Do a mass  update on your table to clear the bad records

UPDATE table SET date=NULL WHERE date='0000-00-00'

[kahodges]

Thank you.