quarter.md

description
Extracts the quarter number (from 1 to 4) for a given date or timestamp.

QUARTER

Syntax

EXTRACT(QUARTER FROM date_timestamp_expression string) → bigint

• date_timestamp_expression: A DATE or TIMESTAMP expression.

Examples

{% code title="QUARTER example using a timestamp." %}

SELECT EXTRACT(QUARTER FROM TIMESTAMP '2019-08-12 01:00:00.123456')
-- 3

{% endcode %}

{% code title="QUARTER example using a date." %}

SELECT EXTRACT(QUARTER FROM DATE '2019-08-12')
-- 3

{% endcode %}

{% code title="QUARTER example using the CAST function." %}

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

{% endcode %}

Usage Notes

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