fortnight interval support
От | Nathan Wagner |
---|---|
Тема | fortnight interval support |
Дата | |
Msg-id | 20151027135211.GA690@granicus.if.org обсуждение исходный текст |
Ответ на | Re: Proposal: Trigonometric functions in degrees (Robert Haas <robertmhaas@gmail.com>) |
Ответы |
Re: fortnight interval support
Re: fortnight interval support Re: fortnight interval support Re: fortnight interval support |
Список | pgsql-hackers |
On Mon, Oct 26, 2015 at 01:58:52PM -0400, Robert Haas wrote: > Aw, you're no fun. select '1 fortnight'::interval => '14 days' would be cool. Patch attached... :) % psql -p 5433 -d template1 -h localhost psql (9.4.5, server 9.6devel) WARNING: psql major version 9.4, server major version 9.6. Some psql features might not work. Type "help" for help. template1=# select current_date; date ------------ 2015-10-27 (1 row) template1=# select '1 fortnight'::interval; interval ---------- 14 days (1 row) template1=# select current_date + '1 fortnight'::interval; ?column? --------------------- 2015-11-10 00:00:00 (1 row) template1=# select current_date + '1.3 fortnight'::interval; ?column? --------------------- 2015-11-14 04:48:00 (1 row) template1=# select current_date + '1.3 fortnights'::interval; ?column? --------------------- 2015-11-14 04:48:00 (1 row) -- nw
Вложения
В списке pgsql-hackers по дате отправления: