mysql 中注意DATE, DATETIME, and TIMESTAMP

最新推荐文章于 2022-11-30 22:59:33 发布

一枝春美食

最新推荐文章于 2022-11-30 22:59:33 发布

阅读量511

点赞数 1

分类专栏：日常记录-mysql 文章标签： mysql

日常记录-mysql 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

一、背景

项目计费时，上一波人在设计db表字段时，将时间类型误用了，导致出现问题。

二、记录

1、依据

mysql官文文档：

https://dev.mysql.com/doc/refman/8.0/en/datetime.html

11.3.1 The DATE, DATETIME, and TIMESTAMP Types

The DATE, DATETIME, and TIMESTAMP types are related. This section describes their characteristics, how they are similar, and how they differ. MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats, described in Section 9.1.3, “Date and Time Literals”. For the DATE and DATETIME range descriptions, “supported” means that although earlier values might work, there is no guarantee.

The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported range is ‘1000-01-01’ to ‘9999-12-31’.

The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in ‘YYYY-MM-DD HH:MM:SS’ format. The supported range is ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’.

The TIMESTAMP data type is used for values that contain both date and time parts. TIMESTAMP has a range of ‘1970-01-01 00:00:01’ UTC to ‘2038-01-19 03:14:07’ UTC.

特别注意的
DATE, DATETIME, and TIMESTAMP
三种类型的。