Data Types MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Data Types
  4. Date-related Data Types
MySQL offers DATETIME, DATE, TIME, YEAR, and TIMESTAMP types.
Data TypeStandard FormatZero value
DATETIMEYYYY-MM-DD HH:MM:SS0000-00-00 00:00:00
DATEYYYY-MM-DD0000-00-00
TIMEHH:MM:SS00:00:00
YEARYYYY0000
TIMESTAMPVaries00000000000000