Categories: Date/Time

MINUTE

Extracts the minute number (from 0 to 59) for a given time or timestamp.

Syntax

EXTRACT(MINUTE FROM date_timestamp_expression string) → bigint

• timestamp_expression: A TIME, TIMESTAMP, or DATE expression.

Examples

MINUTE example using a timestamp

SELECT EXTRACT(MINUTE FROM TIMESTAMP '2019-08-12 01:10:30.123456')
-- 10

MINUTE example using a time

SELECT EXTRACT(MINUTE FROM TIME '01:10:30.123456')
-- 10

MINUTE example using the CAST function

SELECT EXTRACT(MINUTE FROM CAST('2019-08-12 01:10:30' AS TIMESTAMP))
-- 10

Usage Notes

This function uses the EXTRACT function. When using the CAST function, timestamps containing milliseconds are not allowed.