Data Types MySQL Tutorial

Note that the use of these values produces warnings if the NO_ZERO_DATE SQL mode is enabled.
Data TypeZero Value
DATETIME'0000-00-00 00:00:00'
DATE'0000-00-00'
TIMESTAMP'0000-00-00 00:00:00'
TIME'00:00:00'
YEAR0000