Materialize/doc/user/content/sql/functions/justify-interval.md

---

title: "justify_interval function" description: "Adjust interval using justify_days and justify_hours, with additional sign adjustments" menu: main:

parent: 'sql-functions'

---

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

{{< diagram "func-justify-interval.svg" >}}

Parameter	Type	Description
interval	interval	The interval value to justify.

Return value

justify_interval returns an interval value.

Example

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

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