Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

Date Datatypes

There are 5 MySQL date datatypes these are: DatatypeFormatInfo DATETIMEYYYY-MM-DD HH:MM:SSThis stores both date and time. DATEYYYY-MM-DDThis only stores the date TIMESTAMP(length)Depends on the length field TIMEHH:MM:SSThis stores only the time YEARYYYYStores only the year