justify_interval function

justify_interval returns a new interval such that 30-day time periods are converted to months, 24-hour time periods are represented as days, and all fields have the same sign. It is a combination of 'justify_days' and 'justify_hours' with additional sign adjustment.

Signatures

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

Return value

justify_interval returns an interval value.

Example

SELECT justify_interval(interval '1 mon -1 hour');

 justify_interval
------------------
 29 days 23:00:00