Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

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