mysql 分钟_MySQL如何获取一个指定时间中的分钟数(MINUTE函数)呢？

摘要:

下文讲述MySQL数据库中获取指定时间数据中的分钟数的方法分享，如下所示；

实现思路:

使用MINUTE(time)系统函数即可返回日期中的分钟信息

MINUTE系统函数语法说明:

MINUTE(time)

------参数说明----

time:时间数据

------返回值说明-----

返回一个0~59的整型数据

注意事项:

输入一个非时间数据，则返回NULL

例:

mysql> select minute('20200905');

+--------------------+

| minute('20200905') |

+--------------------+

| 59 |

+--------------------+

1 row in set, 1 warning (0.00 sec)

mysql> select minute('20200905 10:10:10');

+-----------------------------+

| minute('20200905 10:10:10') |

+-----------------------------+

| 59 |

+-----------------------------+

1 row in set, 1 warning (0.00 sec)

mysql> select minute('2020-09-05 10:10:10');

+-------------------------------+

| minute('2020-09-05 10:10:10') |

+-------------------------------+

| 10 |

+-------------------------------+

1 row in set (0.00 sec)

mysql> select minute('10:10:10');

+--------------------+

| minute('10:10:10') |

+--------------------+

| 10 |

+--------------------+

1 row in set (0.00 sec)

mysql> select minute('10:20:10');

+--------------------+

| minute('10:20:10') |

+--------------------+

| 20 |

+--------------------+

1 row in set (0.00 sec)

mysql> select minute('10:30:10');

+--------------------+

| minute('10:30:10') |

+--------------------+

| 30 |

+--------------------+

1 row in set (0.00 sec)

mysql> select minute('10:80:10');

+--------------------+

| minute('10:80:10') |

+--------------------+

| NULL |

+--------------------+

1 row in set, 1 warning (0.00 sec)