justify_hours function
justify_hours returns a new interval such that 24-hour time periods are
converted to days.
Signatures
justify_hours ( <interval> )
| Syntax element | Description |
|---|---|
<interval>
|
An interval value to justify. Returns a new interval such that 24-hour time periods are converted to days.
|
| 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