Mega Code Archive

 

Categories / MySQL / Date Time

 

Date and Time Sizes, Formats, and Ranges

Type           Bytes    Format                  Start Date                                  End Date   DATE           3        YYYY-MM-DD              1000-01-01                                  9999-12-31   DATETIME  and TIMESTAMP  8        YYYY-MM-DD HH:MM:SS     1000-01-0100:00:00                          9999-12-31 23:59:59