Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);
От | jian he |
---|---|
Тема | Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); |
Дата | |
Msg-id | CACJufxHYQSKNnt8rS7GxvK04wf75nw_ugMaibFVVfrcdVMmF1Q@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); (David Rowley <dgrowleyml@gmail.com>) |
Ответы |
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);
|
Список | pgsql-bugs |
in `9.9.1. EXTRACT, date_part` EXTRACT(field FROM source) I saw more inconsistencies with the doc when `source` is an interval. the `minute` field select extract(minute from interval '2011 year 16 month 35 day 48 hour 1005 min 71 sec 11 ms'); select extract(minute from interval '2011 year 16 month 35 day 48 hour 1005 min 2 sec 11 ms'); select extract(minute from interval '2011 year 16 month 35 day 48 hour 1005 min 2 sec 11 ms'); the `hour` field: select extract(hour from interval '2011 year 16 month 35 day 48 hour 1005 min 71 sec 11 ms'); select extract(hour from interval '2011 year 16 month 35 day 48 hour 1005 min 2 sec 11 ms'); select extract(hour from interval '2011 year 16 month 35 day 48 hour 1005 min 71 sec 11111111111 ms'); the `quarter` field: select extract(quarter from interval '2011 year 12 month 48 hour 1005 min 2 sec 11 ms'); SELECT EXTRACT(QUARTER FROM TIMESTAMP '2001-12-16 20:38:40');
В списке pgsql-bugs по дате отправления: