Possibly misleading documentation of Template Patterns for Date/Time Formatting

Поиск
Список
Период
Сортировка
От David Kubecka
Тема Possibly misleading documentation of Template Patterns for Date/Time Formatting
Дата
Msg-id CAKtMQEcOQtf6=7s6FO1Sq4bo-GQVWJVujkoL2oiK25v34oUTrQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Possibly misleading documentation of Template Patterns forDate/Time Formatting  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-bugs
Hi,

on the official docs https://www.postgresql.org/docs/9.6/functions-formatting.html see the table 9-24 and Pattern "Q". The doc (for version 9.6) says:

quarter (ignored by to_date and to_timestamp)

All the later versions of the doc (10, 11, 12) miss the "ignored" note leading the user to think that it should work but it doesn't, at least on 12.1:

# select TO_DATE( '2012-4', 'YYYY-Q' );
  to_date  
------------
 2012-01-01
(1 row)

Is this an expected behaviour, i.e. the documentation is just wrong or it really should work?

Regards,

David Kubecka

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16373: Behavior of Temporary table creation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting