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.
SQL Date/Time Column Types
| Data Type | Bytes | Minimum Value | Maximum Value | Format |
|---|---|---|---|---|
| DATE | 4 | 1000-01-01 | 2900-12-31 | YYYY-[M]M-[D]D |
| 1000-01-01 | 2900-12-31 | |||
| DATETIME | 8 | 1000-01-01 00:00:00.000 | 2900-12-31 23:59:59.999 | YYYY-[M]M-[D]D [H]H24:MI:SS[.mmm] |
| 9999-01-01 00:00:00.000 | 9999-12-31 23:59:59.999 | |||
| TIME | 4 | 00:00:00.000 | 23:59:59.999 | [H]H24:MI:SS[.mmm] |
| TIMESTAMP | 8 | -30610224000000 (1/1/1000 00:00:00.000) | 29379542399999 (12/31/2900 23:59:59.999) | Milliseconds since January 1, 1970 00:00:00 |
Native Date/Time Column Types
| Data Type | Column Property | Base Type | Bytes | Minimum Value | Maximum Value | Format |
|---|---|---|---|---|---|---|
| date | date | string | 4 | 1000-01-01 | 2900-12-31 | YYYY-[M]M-[D]D |
| 9999-01-01 | 9999-12-31 | |||||
| datetime | datetime | 8 | 1000-01-01 00:00:00.000 | 2900-12-31 23:59:59.999 | YYYY-[M]M-[D]D [H]H24:MI:SS[.mmm] | |
| 9999-01-01 00:00:00.000 | 9999-12-31 23:59:59.999 | |||||
| time | time | 4 | 00:00:00.000 | 23:59:59.999 | [H]H24:MI:SS[.mmm] | |
| timestamp | timestamp | long | 8 | -30610224000000 (1/1/1000 00:00:00.000) | 29379542399999 (12/31/2900 23:59:59.999) | Milliseconds since January 1, 1970 00:00:00 |
