Date & Time

Date and Time Data Types

---

Name	Storage Size	Resolution	Min Value	Max Value	Description
DATE	2 bytes	day	1000-01-01	9999-12-31	YYYY-MM-DD
DATETIME	4 bytes	second	1970-01-01 00:00:00	2105-12-31 23:59:59	YYYY-MM-DD hh:mm:ss
TIMESTAMP	8 bytes	nanosecond	1677-09-21 00:12:44.000	2262-04-11 23:47:16.854	YYYY-MM-DD hh:mm:ss.ff

Functions

See Date & Time Functions.

Example

CREATE TABLE test_dt
(
    date DATE,
    datetime DATETIME,
    datetime64 TIMESTAMP 
);

DESC test_dt;
+------------+---------------+------+---------+
| Field      | Type          | Null | Default |
+------------+---------------+------+---------+
| date       | Date16        | NO   | 0       |
| datetime   | DateTime32    | NO   | 0       |
| datetime64 | DateTime64(3) | NO   | 0       |
+------------+---------------+------+---------+

INSERT INTO dt VALUES ('2022-04-07', '2022-04-07 01:01:01', '2022-04-07 01:01:01.123');

SELECT * FROM dt;
+------------+---------------------+-------------------------+
| date       | datetime            | datetime64              |
+------------+---------------------+-------------------------+
| 2022-04-07 | 2022-04-07 01:01:01 | 2022-04-07 01:01:01.123 |
+------------+---------------------+-------------------------+