webCOMAND

MINUTE()

Return the minute part of a time or timestamp as an integer from 0-59.

Prototype

integer MINUTE(mixed $timestamp)

Parameters

  • timestamp - A time ("HH:MM:SS") or timestamp ("YYYY-MM-DD HH:MM:SS") followed by optional decimal and microseconds.

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

Related

HOUR(), SECOND(), MICROSECOND()