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