ceiling

Applies ceiling modifier to a date/time value.

This function is useful for operations where you need to ensure a time value is at the very beginning of the next second, effectively discarding any fractional seconds by moving to the next whole second. It corresponds to the ceiling 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:31'.
select(DATETIME().now().ceiling()).execute()

See also