Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

POWER function [Numeric] Next Page

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.

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
Example

The following statement returns the value 2.

SELECT QUARTER( '1987/05/02' );