MySQL HOUR() Function
❮ MySQL Functions
Example
Return the hour part of a datetime:
SELECT HOUR("2017-06-20 09:34:00");
Try it Yourself »
Definition and Usage
The HOUR() function returns the hour part for a given date (from 0 to 838).
Syntax
HOUR(datetime)
Parameter Values
| Parameter |
Description |
| datetime |
Required. The datetime value to extract the hour from |
Technical Details
More Examples
Example
Return the hour part of a datetime:
SELECT HOUR("838:59:59");
Try it Yourself »
❮ MySQL Functions
★
+1
Sign in to track progress
