Date
DATE is a type designed for storing year, month, and day. DATETIME is a type designed for storing year, month, day, hour, minute, seconds, and milliseconds in UTC with 1 millisecond precision.
Date Types
The following table describes the Date types:
Name |
Details |
Data Size (Not Null, Uncompressed) |
Example |
|---|---|---|---|
|
Date |
4 bytes |
|
|
Date and time pairing in UTC |
8 bytes |
|
Aliases
DATETIME is also known as TIMESTAMP or DATETIME2.
Syntax
DATE values are formatted as string literals.
The following is an example of the DATE syntax:
'1955-11-05'
date '1955-11-05'
DATETIME values are formatted as string literals conforming to ISO 8601.
The following is an example of the DATETIME syntax:
'1955-11-05 01:26:00'
SQream attempts to guess if the string literal is a date or datetime based on context, for example when used in date-specific functions.
Size
A DATE column is 4 bytes, while a DATETIME column is 8 bytes.
However, the size of these values is compressed by SQream DB.
Date Examples
The following is an example of the Date syntax:
CREATE TABLE important_dates (a DATE, b DATETIME);
INSERT INTO important_dates VALUES ('1997-01-01', '1955-11-05 01:24');
SELECT * FROM important_dates;
The following is an example of the correct output:
1997-01-01,1955-11-05 01:24:00.0
The following is an example of the Datetime syntax:
SELECT a :: DATETIME, b :: DATE FROM important_dates;
The following is an example of the correct output:
1997-01-01 00:00:00.0,1955-11-05
Date Casts and Conversions
The following table shows the possible DATE and DATETIME value conversions:
Type |
Details |
|---|---|
|
|