this_quarter() function

The this_quarter() function determines the first day of the quarter of a specified date.

Syntax

The this_quarter() function has the following syntax:
date = this_quarter(date input);

The input value specifies a date.

Returns

The function returns a date value that represents the first day of the quarter of the specified input.

Example

select this_quarter('1996-2-29');
 THIS_QUARTER
--------------
 1996-01-01
(1 row)