{"id":2529,"date":"2025-03-21T07:55:48","date_gmt":"2025-03-21T00:55:48","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=2529"},"modified":"2025-04-02T15:30:43","modified_gmt":"2025-04-02T08:30:43","slug":"postgresql-justify_hours","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-date-functions\/postgresql-justify_hours\/","title":{"rendered":"PostgreSQL JUSTIFY_HOURS Function"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you’ll learn how to use the PostgreSQL JUSTIFY_HOURS<\/code> function to adjust an interval by converting 24-hour periods to days.<\/p>\n\n\n\n

PostgreSQL JUSTIFY_HOURS Function Overview #<\/a><\/h2>\n\n\n\n

The\u00a0JUSTIFY_HOURS<\/code>\u00a0function adjusts an interval<\/a> by converting 24-hour periods to days.<\/p>\n\n\n\n

Syntax<\/p>\n\n\n

JUSTIFY_HOURS (value)<\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
The JUSTIFY_HOURS<\/code> function accepts one parameter value<\/code>, which is the interval you want to adjust.<\/p>\n\n\n\n
The JUSTIFY_HOURS<\/code> function checks the value interval and converts hours that exceed 24 to days. It does not change the minutes and seconds.<\/p>\n\n\n\n
The JUSTIFY_HOURS<\/code> function returns NULL<\/code> if the input interval is NULL<\/code>.<\/p>\n\n\n\n
Basic PostgreSQL JUSTIFY_HOURS Function Example #<\/a><\/h2>\n\n\n\n
The following example uses the JUSTIFY_HOURS<\/code> function to adjust 48 hours:<\/p>\n\n\n
SELECT<\/span>\n  JUSTIFY_HOURS(INTERVAL<\/span> '48 hours'<\/span>) result;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
 result\n--------\n 2 days<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
Since 48 hours is 2 days, the function converts it to 2 days.<\/p>\n\n\n\n
Using PostgreSQL JUSTIFY_HOURS() Function with Intervals That Are Not Multiple of 24 Hours #<\/a><\/h2>\n\n\n\n
The following statement uses the JUSTIFY_HOURS<\/code> function to convert 50 hours to days:<\/p>\n\n\n
SELECT<\/span> JUSTIFY_HOURS(INTERVAL<\/span> '50 hours'<\/span>) result;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
     result\n-----------------\n 2 days 02:00:00<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
Using PostgreSQL JUSTIFY_HOURS() Function with Intervals That Include Minutes and Seconds #<\/a><\/h2>\n\n\n\n
The following statement uses the JUSTIFY_HOURS<\/code> function to convert an interval that includes minutes and seconds:<\/p>\n\n\n
SELECT<\/span>\n  JUSTIFY_HOURS(INTERVAL<\/span> '50 hours 45 minutes 30 seconds'<\/span>) result;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
     result\n-----------------\n 2 days 02:45:30<\/code><\/span>Code language:<\/span> plaintext<\/span> (<\/span>plaintext<\/span>)<\/span><\/small><\/pre>\n\n\n
In this example, the JUSTIFY_HOURS<\/code> function converts 50 hours to 2 days and 2 hours. It does not adjust the minutes and seconds.<\/p>\n\n\n\n
Summary #<\/a><\/h2>\n\n\n\n