TO_START_OF_WEEK
Description
Returns the date representing the first day of the week for a specified date.
Syntax
TO_START_OF_WEEK(date) -> Date
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date | Date | Yes | The input date used to determine the start date of its corresponding week. |
Example
TO_START_OF_WEEK(DATE(2025, 4, 16))
-- Returns 2025-04-13, the Sunday before April 16, 2025 (a Wednesday).Tips
Week calculations begin on Sunday.