Search Postgresql Archives

Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





-------- Пересылаемое сообщение--------
11.10.2017, 17:12, "Pavel Stehule" <pavel.stehule@xxxxxxxxx>:

Hi

2017-10-11 12:35 GMT+02:00 <kes-kes@xxxxxxxxx>:
The following bug has been logged on the website:

Bug reference:      14850
Logged by:          Eugen Konkov
Email address:      kes-kes@xxxxxxxxx
PostgreSQL version: 10.0
Operating system:   Linux mint 18: Linux work 4.4.0-57-generic #78-Ubu
Description:

Hi. I try to do next math:

select extract( month from justify_days( timestamp '2016-01-31' +interval '1
month' -timestamp '2016-01-31') );
 date_part
-----------
         0
(1 row)

I expect `1` but get `0`. But here everything is right:

>Adjust interval so 30-day time periods are represented as months

https://www.postgresql.org/docs/9.6/static/functions-datetime.html

But with ability to setup justify date the math will be more sharp.

Please implement next feature:

select extract( month from justify_days( timestamp '2016-01-31' +interval '1
month' -timestamp '2016-01-31'), timestamp '2016-01-31' );
 date_part
-----------
         1
(1 row)

This is useful when I try to calculate how much month are left between
service start and end dates.

This is not the bug, so pgsql-hackers, pgsql-general are better places for this discussion

I am thinking so your request has sense, and should be registered in ToDo list https://wiki.postgresql.org/wiki/Todo

You can try to connect people from PostgreSQL Pro company for implementation.

Regards

Pavel


Thank you.


--
Sent via pgsql-bugs mailing list (pgsql-bugs@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs


-------- Конец пересылаемого сообщения --------

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux