QUARTER: Returning the Quarter of the Year

How to:

Given a date or date-time value, QUARTER returns an integer (from 1 to 4) that represents the quarter within which that date falls.


Top of page

x
Syntax: How to Return the Quarter of the Year
QUARTER(arg)

where:

arg

Date or date-time

Is the input date or date-time value.



Example: Returning the Quarter of the Year

QUARTER returns the quarter of the year for each date of birth:

QUARTER(DATE_OF_BIRTH)

For 1993/03/27, the result is 1.


iWay Software