Returns a number indicating the quarter of the year from the supplied date expression.
QUARTER( date-expression )
date-expression The date.
INT
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/2003 Vendor extension.
The following statement returns the value 2.
SELECT QUARTER( '1987/05/02' ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |