Date/Time Types - Kinetica Docs

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 9999-01-01	2900-12-31 9999-12-31	`YYYY-[M]M-[D]D`
`DATETIME`	8	1000-01-01 00:00:00.000 9999-01-01 00:00:00.000	2900-12-31 23:59:59.999 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 (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 9999-01-01	2900-12-31 9999-12-31	`YYYY-[M]M-[D]D`
datetime	`datetime`	`string`	8	1000-01-01 00:00:00.000 9999-01-01 00:00:00.000	2900-12-31 23:59:59.999 9999-12-31 23:59:59.999	`YYYY-[M]M-[D]D` `[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 (1/1/1000 00:00:00.000)	29379542399999 (12/31/2900 23:59:59.999)	Milliseconds since January 1, 1970 00:00:00

​SQL Date/Time Column Types

​Native Date/Time Column Types

SQL Date/Time Column Types

Native Date/Time Column Types