TO_START_OF_MONTH
Description
Returns the first day of the month for a specified date.
Syntax
TO_START_OF_MONTH(date) -> Date
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| date | Date | Yes | The date for which the start of the month is calculated. |
Example
TO_START_OF_MONTH(DATE(2025, 4, 15))
-- Returns 2025-04-01.