MINUTE()
函数说明
返回 time 的分钟，取值范围为 0 到 59，如果 time 为 NULL 则返回 NULL。
函数语法
> MINUTE(time)
参数释义
| 参数 | 说明 |
|---|---|
| time | 必要参数。表示时间或时间戳的值。 |
示例
- 示例 1：
mysql> SELECT MINUTE('2008-02-03 10:05:03');
+-----------------------------+
| minute(2008-02-03 10:05:03) |
+-----------------------------+
| 5 |
+-----------------------------+
1 row in set (0.00 sec)
- 示例 2：
drop table if exists t1;
create table t1(a datetime, b timestamp);
insert into t1 values("2022-07-01", "2011-01-31 12:00:00");
insert into t1 values("2011-01-31 12:32:11", "1979-10-22");
insert into t1 values(NULL, "2022-08-01 23:10:11");
insert into t1 values("2011-01-31", NULL);
insert into t1 values("2022-06-01 14:11:09","2022-07-01 00:00:00");
insert into t1 values("2022-12-31","2011-01-31 12:00:00");
insert into t1 values("2022-06-12","2022-07-01 00:00:00");
mysql> select minute(a),minute(b) from t1;
+-----------+-----------+
| minute(a) | minute(b) |
+-----------+-----------+
| 0 | 0 |
| 32 | 0 |
| NULL | 10 |
| 0 | NULL |
| 11 | 0 |
| 0 | 0 |
| 0 | 0 |
+-----------+-----------+
7 rows in set (0.00 sec)
mysql> select * from t1 where minute(a)<=minute(b);
+---------------------+---------------------+
| a | b |
+---------------------+---------------------+
| 2022-07-01 00:00:00 | 2011-01-31 12:00:00 |
| 2022-12-31 00:00:00 | 2011-01-31 12:00:00 |
| 2022-06-12 00:00:00 | 2022-07-01 00:00:00 |
+---------------------+---------------------+
3 rows in set (0.00 sec)