Re: [DOCS] Reg Date/Time function

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: [DOCS] Reg Date/Time function
Дата
Msg-id CAEfWYywhKmNBCZuJ6j+_MtuCPSkYBGGhuzxX2yasktDyuzSk3Q@mail.gmail.com
обсуждение исходный текст
Ответ на [DOCS] Reg Date/Time function  (segu.sandeep@gmail.com)
Ответы Re: [DOCS] Reg Date/Time function  (Sandeep Segu <segu.sandeep@gmail.com>)
Список pgsql-docs
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.sandeep@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 &quot;justify_days(interval)&quot;

select justify_days(interval &#39;365 days&#39;);

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

В списке pgsql-docs по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [DOCS] Use of term Master/Slave
Следующее
От: Sandeep Segu
Дата:
Сообщение: Re: [DOCS] Reg Date/Time function