w3resource

PostgreSQL JUSTIFY_INTERVAL() function

JUSTIFY_INTERVAL() function

This function is used to adjust interval using justify_days and justify_hours, with additional sign adjustments.

Syntax:

justify_interval(interval)

Return Type: interval.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL JUSTIFY_INTERVAL() function

Pictorial presentation of PostgreSQL JUSTIFY_INTERVAL() function

Example: PostgreSQL JUSTIFY_INTERVAL() function

Code:

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

Sample Output: 

justify_interval
------------------
 29 days 23:00:00
(1 row)

Previous: JUSTIFY_HOURS function
Next: LOCALTIMESTAMP function