数据库(MySQL)中关于now()返回时间值的学习

使用now()返回时间值

• 根据 now()返回的值分别获取 年份、季度、月份、日期、星期、小时、分钟、秒

(1) 获取年份

SELECT year(now());

mysql> SELECT year(now());
+-------------+
| year(now()) |
+-------------+
|        2021 |
+-------------+
1 row in set (0.00 sec)

(2) 获取季度

SELECT quarter(now());

mysql> SELECT quarter(now());
+----------------+
| quarter(now()) |
+----------------+
|              3 |
+----------------+
1 row in set (0.00 sec)

(3) 获取月份

SELECT month(now());

mysql> SELECT month(now());
+--------------+
| month(now()) |
+--------------+
|            8 |
+--------------+
1 row in set (0.00 sec)

(4) 获取日期

SELECT day(now());
SELECT date(now());

mysql> SELECT day(now());
+------------+
| day(now()) |
+------------+
|         17 |
+------------+
1 row in set (0.00 sec)

mysql> SELECT date(now());
+-------------+
| date(now()) |
+-------------+
| 2021-08-17  |
+-------------+
1 row in set (0.00 sec)

(5) 获取星期

SELECT dayname(now());

mysql> SELECT dayname(now());
+----------------+
| dayname(now()) |
+----------------+
| Tuesday        |
+----------------+
1 row in set (0.12 sec)

(6) 获取小时

SELECT hour(now());

mysql> SELECT hour(now());
+-------------+
| hour(now()) |
+-------------+
|          20 |
+-------------+
1 row in set (0.00 sec)

(7) 获取分钟

SELECT minute(now());

mysql> SELECT minute(now());
+---------------+
| minute(now()) |
+---------------+
|            37 |
+---------------+
1 row in set (0.00 sec)

(8) 获取秒

SELECT second(now());

mysql> SELECT second(now());
+---------------+
| second(now()) |
+---------------+
|            20 |
+---------------+
1 row in set (0.00 sec)