ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns a number indicating the quarter of the year from the supplied date expression.
QUARTER( date-expression )
date- expression The date.
The quarters are as follows:
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 |
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
The following statement returns the value 2.
SELECT QUARTER ( '1987/05/02' )