Tag Archives: maximum and minimum value of date fields in mysql

Supported range of DATE,DATETIME,TIMESTAMP in mysql

DATE- Supported range is ‘1000-01-01’ to ‘9999-12-31’ DATETIME-Supported range is ‘1000-01-01’ to ‘9999-12-31’ TIMESTAMP-Supported range is ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC