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
justify_interval ( <interval> )
| Syntax element | Description |
|---|---|
<interval>
|
An interval value to justify. 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.
|
| 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