HOUR

2023-07-28 02:55:42  Updated

Syntax

HOUR(time)

Purpose

HOUR() returns the hour part of time.

Examples

obclient> SELECT HOUR('10:05:03');
+------------------+
| HOUR('10:05:03') |
+------------------+
|               10 |
+------------------+
1 row in set

obclient> SELECT HOUR('272:59:59');
+-------------------+
| HOUR('272:59:59') |
+-------------------+
|               272 |
+-------------------+
1 row in set

Contact Us