HOUR
更新时间：2025-10-17
描述
获得日期时间中的小时的信息。
语法
SQL
1HOUR(<dt>)参数
| 参数 | 说明 |
|---|---|
<dt> |
需要计算的日期 |
返回值
返回日期中的小时的信息。返回值范围从 0-23。当参数为 Time，返回值可以大于 24
举例
SQL
1select hour('2018-12-31 23:59:59');
Text
1+-----------------------------+
2| hour('2018-12-31 23:59:59') |
3+-----------------------------+
4| 23 |
5+-----------------------------+
SQL
1select cast(4562632 as time),hour(cast(4562632 as time)), minute(cast(4562632 as time)),second(cast(4562632 as time));
Text
1+-----------------------+-----------------------------+-------------------------------+-------------------------------+
2| cast(4562632 as TIME) | hour(cast(4562632 as TIME)) | minute(cast(4562632 as TIME)) | second(cast(4562632 as TIME)) |
3+-----------------------+-----------------------------+-------------------------------+-------------------------------+
4| 456:26:32 | 456 | 26 | 32 |
5+-----------------------+-----------------------------+-------------------------------+-------------------------------+