PROPERTY_NUMBER function [System]  RADIANS function [Numeric]

Chapter 4: SQL 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 A date.

Example

With the DATE_ORDER option set to the default of ymd, the following statement returns the value 2:

SELECT QUARTER ( '1987/05/02' ) FROM iq_dummy

Usage

Table 4-22 lists the dates in the quarters of the year.

Table 4-22: Values of quarter of the year

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

See also

DATE_ORDER option in Reference: Statements and Options




Copyright © 2010. Sybase Inc. All rights reserved. RADIANS function [Numeric]

View this document as PDF