Contents
justify_hours()
A function converting 24 hour intervals into days
justify_hours()
is a system function adjusting an interval
so 24-hour time periods are represented as days.
justify_hours()
was added in PostgreSQL 8.1.
Examples
Basic usage example for justify_hours()
:
postgres=# SELECT justify_hours('28 hours'); justify_hours ---------------- 1 day 04:00:00 (1 row)
References
- PostgreSQL documentation: Date/Time Functions