Possibly misleading documentation of Template Patterns for Date/Time Formatting

From: David Kubecka <davidkubecka366(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Possibly misleading documentation of Template Patterns for Date/Time Formatting
Date: 2020-04-17 15:27:17
Message-ID: CAKtMQEcOQtf6=7s6FO1Sq4bo-GQVWJVujkoL2oiK25v34oUTrQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-04-17 15:52:08 Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting
Previous Message Tom Lane 2020-04-17 13:34:09 Re: BUG #16373: Behavior of Temporary table creation