QUARTER function [Date and time]

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

Syntax 
QUARTER( date-expression )
Parameters

  • date-expression   The date.

Returns

INT

Remarks

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
Standards and compatibility

  • SQL/2003   Vendor extension.

Example

The following statement returns the value 2.

SELECT QUARTER( '1987/05/02' );
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1