MINUTE

Returns the minute portion of the specified date as an integer.

Behavior type

• Immutable if thespecified date is a TIMESTAMP, DATE, VARCHAR or INTERVAL

• Stable if the specified date is aTIMESTAMPTZ

Syntax

MINUTE ( date )

Parameters

date

The date to process, one of the following data types:

• VARCHAR
• DATE
• TIMESTAMP
• TIMESTAMPTZ

• INTERVAL

Examples

=> 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)