- ⌂ Date & Time
- Functions
HOUR()
Return the hour part of a time or timestamp as an integer from 0-23.
Prototype
integer HOUR(mixed $timestamp)
Parameters
- timestamp - A date ("YYYY-MM-DD") or timestamp ("YYYY-MM-DD HH:MM:SS").
Return
The hour portion of a time or timestamp, or NULL if there is an error, such as an invalid timestamp.
Example
SELECT OID, HOUR('12:05:22.234') AS Hour FROM User
See Also
MINUTE(), SECOND(), MICROSECOND()