摘要:
下文讲述MySQL数据库中获取指定时间数据中的小时数的方法分享,如下所示;
实现思路:
使用hour(time)系统函数即可返回日期中的年份信息
hour系统函数语法说明:
hour(time)
------参数说明----
time:时间数据
------返回值说明-----
返回时间数据中的小时部分
注意事项:
1.输入一个异常时间数据,会返回一个NULL
2.输入一个日期时间数据,会返回一个异常数据及警告信息
3.理论上此函数返回一个0~23之间的整数
例:
mysql> select hour('20200905');
+------------------+
| hour('20200905') |
+------------------+
| 838 |
+------------------+
1 row in set, 1 warning (0.00 sec)
mysql> select hour('20200905 10:00:00');
+---------------------------+
| hour('20200905 10:00:00') |
+---------------------------+
| 838 |
+---------------------------+
1 row in set, 1 warning (0.00 sec)
mysql> select hour('10:00:00');
+------------------+
| hour('10:00:00') |
+------------------+
| 10 |
+------------------+
1 row in set (0.00 sec)
mysql> select hour('10:00:10');
+------------------+
| hour('10:00:10') |
+------------------+
| 10 |
+------------------+
1 row in set (0.00 sec)
mysql> select hour('12:00:10');
+------------------+
| hour('12:00:10') |
+------------------+
| 12 |
+------------------+
1 row in set (0.00 sec)
mysql> select hour('12:00:1011');
+--------------------+
| hour('12:00:1011') |
+--------------------+
| NULL |
+--------------------+
1 row in set, 1 warning (0.00 sec)
mysql> select hour('1222:00:1011');
+----------------------+
| hour('1222:00:1011') |
+----------------------+
| NULL |
+----------------------+
1 row in set, 1 warning (0.00 sec)