Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

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