this_week() function
The this_week() function determines the first day of the week in a specified date.
Syntax
The this_week() function has the following
syntax:
date = this_week(date input);
The input value
specifies a date.
Returns
The function returns a date value that represents the first day of the week in the specified input.
Example
select this_week('1996-2-29');
THIS_WEEK
------------
1996-02-25
(1 row)