Per the docs, justify_days is to "Adjust interval so 30-day time periods are represented as months" so 360 days = 12 months = 1 year so 365 days is 1-year 5-days.
There are all sorts of oddities and special assumptions regarding date/time calculations made even more complicated by the need to support special use-cases such as 30/360 financial coupon factor calculations (every month is 30-days and years have 360 days). Cheers, Steve On Mon, Jul 31, 2017 at 5:30 PM, <segu.sand...@gmail.com> wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/8.2/static/functions-datetime.html > Description: > > Hi, > I am going through PostgreSQL, for the first day. And it was great till > now. > One quick question/doubt regarding the function > "justify_days(interval)" > > select justify_days(interval '365 days'); > > this statement returns 1 year 5 days, whereas I feel it should be just 1 > year. > > Please correct me if I am wrong.. Thanks for all your time. > > -- > Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-docs >
