Functions / Date/Time Functions And Operators

justify_days

Adjust interval, converting 30-day time periods to months

Reading PG 18current·documented in 22 of 27 versions, 8.1 to 20

Signatures & examples

justify_days ( interval ) → interval

Adjust interval, converting 30-day time periods to months

justify_days(interval '1 year 65 days') → 1 year 2 mons 5 days

Version history 2

Definition snapshot: b7bd9cda · English manual source