QUARTER

Retrieves the quarter of the year from a given date or datetime

Description

The QUARTER function extracts and returns the quarter of the year (e.g., 1, 2, 3, 4) from a given date or datetime. This is useful for time-based analysis, organizing data by quarters, or generating quarterly reports.

Syntax

QUARTER(date)

  1. date: The date or datetime from which you want to extract the quarter.

Example

Table

Statement
Date

Statement A

2023-03-15

Statement B

2023-07-30

Statement C

2023-11-05

Function

QUARTER(`Date`)

Results

QUARTER (integer)

1

3

4

Last updated