Categories: Date/Time

MONTH

Extracts the month number (from 1 to 12) for a given date or timestamp.

Syntax

EXTRACT(MONTH FROM date_timestamp_expression string) → bigint

• date_timestamp_expression: A DATE or TIMESTAMP expression.

Examples

MONTH example using a timestamp

SELECT EXTRACT(MONTH FROM TIMESTAMP '2019-08-12 01:00:00.123456')
-- 8

MONTH example using a date

SELECT EXTRACT(MONTH FROM DATE '2019-08-12')
-- 8

MONTH example using the CAST function

SELECT EXTRACT(MONTH FROM CAST('2019-08-12 01:00:00' AS TIMESTAMP))
-- 8

Usage Notes

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