In MySQL date data type, if the date value is not provided while inserting record, ‘0000-00-00’ will be added as
If you want to insert empty value for date field and do not want it saved as 0000-00-00, make your date firled NULL as default and do one of the following.
Either specify the data as NULL, or omit the field from the insert query, e.g.:
INSERT INTO table SET name='PI Media'; OR INSERT INTO table (name, date) VALUES ('PI Media', NULL);
Hope that helps.