根据MySQL internals
documentation,由于特定的存储要求,它是必需的:
+-----------+------------------------+---------------------+
| YEAR | 1 byte, little endian | Unchanged |
+-----------+------------------------+---------------------+
| DATE | 3 bytes, little endian | Unchanged |
+-----------+------------------------+---------------------+
| | | 3 bytes + |
| TIME | 3 bytes, little endian | fractional-seconds |
| | | storage, big endian |
+-----------+------------------------+---------------------+
| | | 4 bytes + |
| TIMESTAMP | 4 bytes, little endian | fractional-seconds |
| | | storage, big endian |
+-----------+------------------------+---------------------+
| | | 5 bytes + |
| DATETIME | 8 bytes, little endian | fractional-seconds |
| | | storage, big endian |
+-----------+------------------------+---------------------+
特别是,DATETIME有8个字节:
> 4字节:日期的整数表示为YYYY×10000 MM×100 DD
> 4字节:时间的整数表示为HH×10000 MM×100 SS
因此,重要的是要意识到,输出表示和存储表示是两个非常不同的事情.如您所见,datetime的结构是两个整数,两个部分都有一些内部计算 – 日期和时间.