Type: Function
Function: BEGINNING_OF_WEEK
Syntax: BEGINNING_OF_WEEK(datetime)
Description: Returns a datetime corresponding to the beginning of week (Monday) for the provided datetime or NOW if no value is provided.
Sample usage:
BEGINNING_OF_WEEK(created_at)returns thecreated_atfield value set at midnight on the first day of the week. Ifcreated_atis equal to2023-02-23T15:39:21ZthenBEGINNING_OF_WEEK(created_at)returns2023-02-20T00:00:00Z.
BEGINNING_OF_WEEK()is equivalent toBEGINNING_OF_WEEK(NOW())
BEGINNING_OF_WEEK(DATE(2023, 3, 15))is equal toDATE(2023, 3, 13)