# Date and Time Data Types

- [DATE](/docs/server/reference/data-types/date-and-time-data-types/date.md): Complete DATE type reference: YYYY-MM-DD format, YYMMDD input literals, date range 1000-01-01 to 9999-12-31, and zero-date SQL\_MODE handling.
- [DATETIME](/docs/server/reference/data-types/date-and-time-data-types/datetime.md): Complete DATETIME data type guide for MariaDB. Complete reference for syntax, valid values, storage requirements, and range limits for production use.
- [SQL\_TSI\_YEAR](/docs/server/reference/data-types/date-and-time-data-types/sql_tsi_year.md): Synonym for YEAR. This keyword is an alias used for declaring a column to store year values.
- [TIME](/docs/server/reference/data-types/date-and-time-data-types/time.md): Store time values. This type handles time durations or time of day, ranging from '-838:59:59' to '838:59:59' with optional microsecond precision.
- [TIMESTAMP](/docs/server/reference/data-types/date-and-time-data-types/timestamp.md): Complete TIMESTAMP data type guide for MariaDB. Complete reference for syntax, valid values, storage requirements, and range limits for production use.
- [YEAR Data Type](/docs/server/reference/data-types/date-and-time-data-types/year-data-type.md): Store year values. This type stores a year in 2-digit or 4-digit format, supporting values from 1901 to 2155, and 0000.