MySQL HOUR()

MySQL 날짜함수, 시간함수

 

HOUR()

- 시간에 대한 시 값을 알려준다. (HOUR)

 

 

HOUR(time)

의 형태

 

Returns the hour for time. The range of return value is 0 to 23 for time-of-day values. Howerer the range of TIME values actually is much larger, so HOUR can return values greater than 23. 

 

 

mysql> SELECT HOUR(NOW());
+-------------+
| HOUR(NOW()) |
+-------------+
|          12 |
+-------------+
1 row in set (0.00 sec)

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

mysql> SELECT HOUR('272:05:03');
+-------------------+
| HOUR('272:05:03') |
+-------------------+
|               272 |
+-------------------+
1 row in set (0.00 sec)