Mega Code Archive

 

Categories / MySQL / Date Time

 

Date and Time Column Types

Type                 Description   DATETIME             YYYY-MM-DD HH:MM:SS from 1000-01-01 00:00:00 to 9999-12-31 23:59:59    DATE                 YYYY-MM-DD from 1000-01-01 to 9999-12-31    TIMESTAMP            YYYYMMDDHHMMSS    TIME                 HH:MM:SS    YEAR                 YYYY