Thank you Steve for the information. Thanks, Sandeep Segu.
On Tue, Aug 1, 2017 at 2:04 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > 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 >> > >
