Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jPTHq-0004o5-5I for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Apr 2020 15:52:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jPTHp-0005S7-0H for pgsql-bugs@arkaria.postgresql.org; Fri, 17 Apr 2020 15:52:13 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jPTHo-0005S0-Qa for pgsql-bugs@lists.postgresql.org; Fri, 17 Apr 2020 15:52:12 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jPTHm-00021O-Id for pgsql-bugs@postgresql.org; Fri, 17 Apr 2020 15:52:11 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id 03HFq8QT004090; Fri, 17 Apr 2020 11:52:08 -0400 From: Tom Lane To: David Kubecka cc: pgsql-bugs@postgresql.org Subject: Re: Possibly misleading documentation of Template Patterns for Date/Time Formatting In-reply-to: References: Comments: In-reply-to David Kubecka message dated "Fri, 17 Apr 2020 17:27:17 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <4088.1587138728.1@sss.pgh.pa.us> Date: Fri, 17 Apr 2020 11:52:08 -0400 Message-ID: <4089.1587138728@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk David Kubecka writes: > 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 It's still there, just further down: * In to_timestamp and to_date, weekday names or numbers (DAY, D, and related field types) are accepted but are ignored for purposes of computing the result. The same is true for quarter (Q) fields. I think this was changed because we noticed that the docs failed to point out the issue for weekday fields, and cramming similar annotations into their already-long table entries didn't make sense. So the info got moved to the commentary below. regards, tom lane