Data Types MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Data Types
  4. The format of the zero value for each type
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