startOfMonth

Applies start of month modifier to a date/time value.

This function translates to the 'start of month' modifier in SQLite's date and time functions. It rewinds the date to the beginning of the month it is in. For example, if the date is '2024-07-15', applying this modifier will change it to '2024-07-01'.

Example

// Get the first day of the current month
select(DATE().now().startOfMonth()).execute()

See also