PostgreSQL JUSTIFY HOURS
From w3cyberlearnings
Contents |
Postgresql justify_hours
This function returns the adjust interval period to days and hour for a given hour. (24 hours represented as 1 day)
Syntax justify_hours
justify_hours(interval);
Example 1
postgres=# SELECT justify_hours(interval '65 hours');
justify_hours
-----------------
2 days 17:00:00
(1 row)
postgres=# SELECT justify_hours(interval '419 hours');
justify_hours
------------------
17 days 11:00:00
(1 row)
Example 2
Related Links
- justify_hours
- justify_interval
- localtime
- localtimestamp
- now
