> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Date/Time Types

There are three categories of date/time data types supported in both SQL and
natively via API:

* *Date*
* *Time*
* *Timestamp*

Support for the *timestamp* type comes in two flavors, depending on whether the
data being ingested into Kinetica is numeric (milliseconds since the Epoch) or
string (date/time literal).  Once ingested, both of these types and stored and
processed in the same way.

<a id="ts-column-types-sql" />

<a id="sql-date-time-column-types" />

## SQL Date/Time Column Types

| Data Type | Bytes | Minimum Value | Maximum Value | Format |
| - | - | - | - | - |
| `DATE` | 4 | 1000-01-01 <br /> 9999-01-01 | 2900-12-31 <br /> 9999-12-31 | `YYYY-[M]M-[D]D` |
| `DATETIME` | 8 | 1000-01-01 00:00:00.000 <br /> 9999-01-01 00:00:00.000 | 2900-12-31 23:59:59.999 <br /> 9999-12-31 23:59:59.999 | `YYYY-[M]M-[D]D [H]H24:MI:SS[.mmm]` |
| `TIME` | 4 | 00:00:00.000 | 23:59:59.999 | `[H]H24:MI:SS[.mmm]` |
| `TIMESTAMP` | 8 | -30610224000000 <br /> <br /> (1/1/1000 00:00:00.000) | 29379542399999 <br /> <br /> (12/31/2900 23:59:59.999) | Milliseconds since <br /> <br /> *January 1, 1970 00:00:00* |

<a id="ts-column-types-native" />

<a id="native-date-time-column-types" />

## Native Date/Time Column Types

| Data Type | Column Property | Base Type | Bytes | Minimum Value | Maximum Value | Format |
| - | - | - | - | - | - | - |
| *date* | `date` | `string` | 4 | 1000-01-01 <br /> 9999-01-01 | 2900-12-31 <br /> 9999-12-31 | `YYYY-[M]M-[D]D` |
| *datetime* | `datetime` | `string` | 8 | 1000-01-01 00:00:00.000 <br /> 9999-01-01 00:00:00.000 | 2900-12-31 23:59:59.999 <br /> 9999-12-31 23:59:59.999 | `YYYY-[M]M-[D]D` <br /> `[H]H24:MI:SS[.mmm]` |
| *time* | `time` | `string` | 4 | 00:00:00.000 | 23:59:59.999 | `[H]H24:MI:SS[.mmm]` |
| *timestamp* | `timestamp` | `long` | 8 | -30610224000000 <br /> <br /> (1/1/1000 00:00:00.000) | 29379542399999 <br /> <br /> (12/31/2900 23:59:59.999) | Milliseconds since <br /> <br /> *January 1, 1970 00:00:00* |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.