QUARTER

​

Syntax

​

Scalar

quarter(value)

​

Arguments

​

Returns

• Type: INTEGER
• Possible values: 1 through 4.
• NULL behavior: NULL input returns NULL.

​

Properties

​

Usage notes

• QUARTER(value) gives the same INTEGER result as EXTRACT(QUARTER FROM value).
• Deterministic: The same inputs and settings produce the same result.

​

Examples

​

Typical behavior

SELECT quarter(DATE '2024-03-15') AS "value";

​

Quarter boundaries

SELECT quarter(DATE '2024-03-31') AS march, quarter(DATE '2024-04-01') AS april;

​

Related functions

• date_part