floor

Applies floor modifier to a date/time value.

This function is useful for operations where you need to discard any fractional seconds from a time value. It corresponds to the floor modifier in SQLite's date and time functions, which was introduced in SQLite version 3.46.0.

Example

// If the current time is '10:20:30.123', this will result in '10:20:30'.
select(DATETIME().now().floor()).execute()

See also