QUARTERSTART scalar function

Returns the first day of the quarter that ADATE exists within, or the first day of the quarter AQUARTER in the year AYEAR.

Prototypes

QUARTERSTART(AYEAR INTEGER, AQUARTER INTEGER)
QUARTERSTART(ADATE DATE)
QUARTERSTART(ADATE TIMESTAMP)
QUARTERSTART(ADATE VARCHAR(26))

RETURNS DATE

Description

Returns a DATE representing the first day of AQUARTER in AYEAR, or the first day of the quarter of ADATE depending on the variant of the function that is called.

Parameters

AYEAR
If provided, the year of AQUARTER for which to return the starting date.
AQUARTER
If provided, the quarter for which to return to the starting date.
ADATE
If provided the date in the quarter for which to return the starting date. Either AYEAR and AQUARTER, or ADATE must be specified.

Examples

Calculate the starting date of the second quarter in 2010:

VALUES QUARTERSTART(2010, 2);

1
----------
2010-04-01

Calculate the start date of the quarter containing the first of February, 2010:

VALUES QUARTERSTART('2010-02-01');

1
----------
2010-01-01

See Also