w3resource

PostgreSQL JUSTIFY_DAYS() function

JUSTIFY_DAYS() function

This function is used to adjust interval so 30-day time periods are represented as months.

Syntax:

justify_days(interval)

Return Type:interval.

PostgreSQL Version: 9.3

Pictorial Presentation of PostgreSQL JUSTIFY_DAYS() function

Pictorial presentation of PostgreSQL JUSTIFY_DAYS() function

Example 1: PostgreSQL JUSTIFY_DAYS() function

Code:

SELECT justify_days(interval '47 days');

Sample Output: 

 justify_days
---------------
 1 mon 17 days
(1 row)

Previous: ISFINITE function
Next: JUSTIFY_HOURS function