startOfDay

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

This function translates to the 'start of day' modifier in SQLite's date and time functions. It rewinds the time to midnight (00:00:00) for the given date. For example, if the date/time is '2024-07-15 14:30:00', applying this modifier will change it to '2024-07-15 00:00:00'.

Example

// Get the start of the current day (midnight)
select(DATETIME().now().startOfDay()).execute()

See also