Hi,

I have a table with a column like:

date date default null,

If I enter an empty string in it, the default null value is added (as it 
should).

But if I enter an invalid date by mistake, the date 0000-00-00 date date is 
entered instead of the default null, and this is not good.

Can I do something to force MySQL to insert a null date if the entered date 
is an invalid one?

Thank you.

--
Octavian




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to