MINUTE
Returns the minute portion of the specified date as an integer.
Behavior Type
- Immutable if the
specified date is a
TIMESTAMP
,DATE
,VARCHAR
orINTERVAL
- Stable if the specified date is a
TIMESTAMPTZ
Syntax
MINUTE ( date )
Parameters
date |
The date to process, one of the following data types: |
Example
=> SELECT MINUTE('12:34:03.456789'); MINUTE -------- 34 (1 row) =>SELECT MINUTE (TIMESTAMP 'sep 22, 2011 12:34'); MINUTE -------- 34 (1 row) => SELECT MINUTE(INTERVAL '35 12:34:03.456789'); MINUTE -------- 34 (1 row)