justify_hours function

justify_hours returns a new interval such that 24-hour time periods are converted to days.

Signatures

{{% include-syntax file="examples/sql_functions/justify_hours" example="syntax" %}}

Return value

justify_hours returns an interval value.

Example

SELECT justify_hours(interval '27 hours');

 justify_hours
----------------
 1 day 03:00:00