quarter

Return the quarter

Syntax

quarter(dt_expr)

Arguments

dt_expr

A date expression.

Description

This function returns the number of the quarter in the specified date expression as a number between 1 and 4.

Example

select quarter(curdate()) of "Current Quarter";

Current Quarter
              2