Skip to main content
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 TypeBytesMinimum ValueMaximum ValueFormat
DATE41000-01-01
9999-01-01		2900-12-31
9999-12-31		YYYY-[M]M-[D]D
DATETIME81000-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]
TIME400:00:00.00023:59:59.999[H]H24:MI:SS[.mmm]
TIMESTAMP8-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 TypeColumn PropertyBase TypeBytesMinimum ValueMaximum ValueFormat
datedatestring41000-01-01
9999-01-01		2900-12-31
9999-12-31		YYYY-[M]M-[D]D
datetimedatetimestring81000-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]
timetimestring400:00:00.00023:59:59.999[H]H24:MI:SS[.mmm]
timestamptimestamplong8-30610224000000

(1/1/1000 00:00:00.000)		29379542399999

(12/31/2900 23:59:59.999)		Milliseconds since

January 1, 1970 00:00:00