【MySQL】内置函数——日期函数

---

//显示当前日期
mysql> select current_date();
+----------------+
| current_date() |
+----------------+
| 2023-10-09     |
+----------------+
//显示当前时间
mysql> select current_time();
+----------------+
| current_time() |
+----------------+
| 22:37:21       |
+----------------+
//显示当前时间戳
mysql> select current_timestamp();
+---------------------+
| current_timestamp() |
+---------------------+
| 2023-10-09 22:37:30 |
+---------------------+
//显示当前日期+时间
mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2023-10-09 22:48:56 |
+---------------------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28

---

//加上13天
mysql> select date_add('2013-10-10',interval 13 day);
+----------------------------------------+
| date_add('2013-10-10',interval 13 day) |
+----------------------------------------+
| 2013-10-23                             |
+----------------------------------------+
//减去14天
mysql> select date_sub('2013-10-10',interval 14 day);
+----------------------------------------+
| date_sub('2013-10-10',interval 14 day) |
+----------------------------------------+
| 2013-09-26                             |
+----------------------------------------+
//计算两个日期相差的天数
mysql> select datediff('2018-10-3','2012-9-1');
+----------------------------------+
| datediff('2018-10-3','2012-9-1') |
+----------------------------------+
|                             2223 |
+----------------------------------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

---

//date获取datetime的日期部分
mysql> select date(current_timestamp);
+-------------------------+
| date(current_timestamp) |
+-------------------------+
| 2023-10-09              |
+-------------------------+

mysql> select date(now());
+-------------+
| date(now()) |
+-------------+
| 2023-10-09  |
+-------------+
1
2
3
4
5
6
7
8
9
10
11
12
13
14