# eXtremeSQL DateTime Data

> eXtremeSQL provides the SQL data types `DATE`, `TIME` and `TIMESTAMP` to manage date and time values.

> ### For an overview see page SQL Data Types

> The table in page SQL Data Types shows that these three SQL types, `DATE`, `TIME` and `TIMESTAMP`, map to underlying 8-byte eXtremeDB `datetime` values.

>         create table dt( d date, t time, ts timestamp );

>         select FieldName, FieldTypeName from Metatable
>         where TableName = 'dt';
>         FieldName       FieldTypeName
>         ----------------------------------------------------------------------
>         d       DateTime
>         t       DateTime
>         ts      DateTime

> See page Date, Time and Datetime Fields for further information on how these fields are managed in SQL and native language APIs.