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

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
- Exercises: Weekly Top 12 Most Popular Topics
- Pandas DataFrame: Exercises, Practice, Solution
- Conversion Tools
- JavaScript: HTML Form Validation
- SQL Exercises, Practice, Solution - SUBQUERIES
- C Programming Exercises, Practice, Solution : For Loop
- Python Exercises, Practice, Solution
- Python Data Type: List - Exercises, Practice, Solution
- C++ Basic: Exercises, Practice, Solution
- SQL Exercises, Practice, Solution - exercises on Employee Database
- SQL Exercises, Practice, Solution - exercises on Movie Database
- SQL Exercises, Practice, Solution - exercises on Soccer Database
- C Programming Exercises, Practice, Solution : Recursion