Materialize Documentation
s
Join the Community github/materialize

justify_hours function

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

Signatures

justify_hours ( interval )
Parameter Type Description
interval interval The interval value to justify.

Return value

justify_hours returns an interval value.

Example

SELECT justify_hours(interval '27 hours');
 justify_hours
----------------
 1 day 03:00:00