Date and Time Types

Date and Time

---

Data Type	Size	Resolution	Min Value	Max Value	Precision
Date	2 byte	day	1000-01-01	9999-12-31	YYYY-MM-DD
DateTime	4 byte	second	1970-01-01 00:00:00	2105-12-31 23:59:59	YYYY-MM-DD hh:mm:ss
DateTime64	8 byte	nanosecond	1677-09-21 00:12:44.0	2262-04-11 23:47:16.854775804	YYYY-MM-DD hh:mm:ss.ff

Example

mysql>

CREATE TABLE dt
(
    date Date,
    datetime DateTime,
    datetime64 DateTime64
);

mysql>

desc dt;

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

mysql>

insert into dt values ('2022-04-07', '2022-04-07 01:01:01', '2022-04-07 01:01:01.123');

mysql>

select * from dt;

+------------+---------------------+-------------------------+
| date       | datetime            | datetime64              |
+------------+---------------------+-------------------------+
| 2022-04-07 | 2022-04-07 01:01:01 | 2022-04-07 01:01:01.123 |
+------------+---------------------+-------------------------+