> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/data-types/date-and-time-data-types.md).

# Date and Time Data Types

{% columns %}
{% column %}
{% content-ref url="/pages/FvPFz7DHjMrdtD6qXHTz" %}
[DATE](/docs/server/reference/data-types/date-and-time-data-types/date.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/J1NhBaayQxo76SuocE0E" %}
[DATETIME](/docs/server/reference/data-types/date-and-time-data-types/datetime.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete DATETIME data type guide for MariaDB. Complete reference for syntax, valid values, storage requirements, and range limits for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/VxgMOtsv2N3R76xzzcvs" %}
[SQL\_TSI\_YEAR](/docs/server/reference/data-types/date-and-time-data-types/sql_tsi_year.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Synonym for YEAR. This keyword is an alias used for declaring a column to store year values.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/cdP5prV74P80P8dArrQR" %}
[TIME](/docs/server/reference/data-types/date-and-time-data-types/time.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
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.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/1RwPMKKyXFFK9ZH04juU" %}
[TIMESTAMP](/docs/server/reference/data-types/date-and-time-data-types/timestamp.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Complete TIMESTAMP data type guide for MariaDB. Complete reference for syntax, valid values, storage requirements, and range limits for production use.
{% endcolumn %}
{% endcolumns %}

{% columns %}
{% column %}
{% content-ref url="/pages/fu8s0NY9fIj2y6l9HMvC" %}
[YEAR Data Type](/docs/server/reference/data-types/date-and-time-data-types/year-data-type.md)
{% endcontent-ref %}
{% endcolumn %}

{% column %}
Store year values. This type stores a year in 2-digit or 4-digit format, supporting values from 1901 to 2155, and 0000.
{% endcolumn %}
{% endcolumns %}