QUARTER function [Date and time]

Function

Returns a number indicating the quarter of the year from the supplied date expression.

Syntax

QUARTERdate-expression )

Parameters

date-expression A date.

Example

With the DATE_ORDER option set to the default of ymd, the following statement returns the value 2:

SELECT QUARTER ( '1987/05/02' ) FROM iq_dummy

Usage

Table 4-26 lists the dates in the quarters of the year.

Table 4-26: Values of quarter of the year

Quarter

Period (inclusive)

1

January 1 to March 31

2

April 1 to June 30

3

July 1 to September 30

4

October 1 to December 31

Standards and compatibility

See also

DATE_ORDER option in Reference: Statements and Options