Re: Workbench Stored Procedure not working with date '0000-00-00'

[Guru Cus]

Looks like the third line:

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

sets the mode to traditional, which sets the STRICT_ flags and doesn't allow invalid dates (well, it seems not invalid years)

I set it to:

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ALLOW_INVALID_DATES';

and it's all working fine now.

Probably the Query Browser set it to something else so the checking wasn't done anymore.

More info: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html