Contents Index PROPERTY_NUMBER function [System] RADIANS function [Numeric]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

QUARTER function [Date and time]


Function 

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

Syntax 

QUARTER( date-expression )

Parameters 

date- expression    The date.

Usage 

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' )

Contents Index PROPERTY_NUMBER function [System] RADIANS function [Numeric]