Returns the last day of the quarter that ADATE exists within, or the last day of the quarter AQUARTER in the year AYEAR.
QUARTEREND(AYEAR INTEGER, AQUARTER INTEGER)
QUARTEREND(ADATE DATE)
QUARTEREND(ADATE TIMESTAMP)
QUARTEREND(ADATE VARCHAR(26))
RETURNS DATE
Returns a DATE representing the last day of AQUARTER in AYEAR, or the last day of the quarter of ADATE depending on the variant of the function that is called.
- AYEAR
If provided, the year of AQUARTER for which to return the ending date.
- AQUARTER
If provided, the quarter for which to return to the ending date.
- ADATE
If provided the date in the quarter for which to return the ending date. Either AYEAR and AQUARTER, or ADATE must be specified.
Calculate the ending date of the second quarter in 2010:
VALUES QUARTEREND(2010, 2);
1
----------
2010-06-30
Calculate the end date of the quarter containing the first of February, 2010:
VALUES QUARTEREND('2010-02-01');
1
----------
2010-03-31
- Source code
QUARTER_START
- QUARTER (built-in function)