IBM PureData System for Analytics, Version 7.1

The this_week() function

The this_week() function determines the first day of the week in the specified date.

Description

The this_week() function has the following syntax:

date = this_week(date input);

The input value specifies a date.

Returns a date value that represents the first day of the week specified by input. For example:

select this_week('1996-2-29');
 THIS_WEEK
------------
 1996-02-25
(1 row)