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
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
- Weekly Trends and Language Statistics
- Weekly Trends and Language Statistics