Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wH8Cp-006tJM-16 for pgsql-bugs@arkaria.postgresql.org; Sun, 26 Apr 2026 22:44:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wH8Cm-00BMDH-1q for pgsql-bugs@arkaria.postgresql.org; Sun, 26 Apr 2026 22:44:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wH8Cm-00BMD8-10 for pgsql-bugs@lists.postgresql.org; Sun, 26 Apr 2026 22:44:00 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wH8Ck-00000003ETj-1ZPl for pgsql-bugs@lists.postgresql.org; Sun, 26 Apr 2026 22:44:00 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 40FC5140005A; Sun, 26 Apr 2026 18:43:57 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Sun, 26 Apr 2026 18:43:57 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1777243437; x=1777329837; bh=TRPMJhaH+F BDtFmJGI3qZJATKSUsmxTLoy3CJKCsGFo=; b=P/8EyT6vsoB5o70PzMcOUeNByy /X95wT3U2y3A78lY0jpYHEFrVbsuPKDRYw7GgzRfXuP32Zh80peicGb1CuTkSoUK vm4V3qwFjTw/p7YD5pPZQqd0PgCpui6gJ7U4h++wocJht8C4YF8z3Z+JVsthizvk f4lbbaz1LPEWFBYWLPAQLLVSaGG+veoKKIWZxW8nEllrLnAp1Eyl6+q+DY5BEq1+ sbSyw0NgpiZR8OV5N+NZba74ZSxeszkQN4V3YL66dhQGf+cFRdVxdok9oVdOlvtJ jB12I1lUFYW43YCc4E5V7nOBsTZ+jx0X9C7LL6GqVIWchugrQk8cdvkj7wjA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1777243437; x=1777329837; bh=TRPMJhaH+FBDtFmJGI3qZJATKSUsmxTLoy3 CJKCsGFo=; b=q4f/B9JsrjAiCfq2FS3yvZ393vTP3CqspIci2uPipG/LAerQui3 zzPEWSOROmgOxUsKMdrM6UBZB/3IzGnEGeSKmDr3h1BIBOHE1xVI9ogMf0Cr4NPU mj+crpGd/A1jt4TXvS5wLbRemhUd3bJMfPVr8lXYCDrrVl6yIfT4idzGeNpz8FAS LSUQ5oGgO0GjKW5+tmGb/7sWP4gEKicXPz9W56xPUR2qsJeGlwH7nkO50SPreHt3 kfi3IPMsdd/poRHR8QEqoUj+NKt8L5qBqcqlhnz0xTsJwwdIeiH1xyjBDiOAjEdO Xp9r+e+GQTfGFG+WNXYBGxct7zyMh+IzSxw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdejjedtfecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfghrlh cuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddtvden ucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprghquh hivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeggeff hfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtnecurf grrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiipdhn sggprhgtphhtthhopeehpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehpvghtvg hrsegvihhsvghnthhrrghuthdrohhrghdprhgtphhtthhopehtghhlsehsshhsrdhpghhh rdhprgdruhhspdhrtghpthhtohepuggrnhhivghlseihvghsqhhlrdhsvgdprhgtphhtth hopegrhihushhhthhifigrrhhirdhslhhgtddusehgmhgrihhlrdgtohhmpdhrtghpthht ohepphhgshhqlhdqsghughhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 26 Apr 2026 18:43:55 -0400 (EDT) Date: Mon, 27 Apr 2026 07:43:51 +0900 From: Michael Paquier To: Peter Eisentraut Cc: Tom Lane , Daniel Gustafsson , Ayush Tiwari , pgsql-bugs@lists.postgresql.org Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0 Message-ID: References: <1444609.1776958814@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5lKOtOPzdsJ8112n" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --5lKOtOPzdsJ8112n Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Apr 24, 2026 at 05:41:50PM +0200, Peter Eisentraut wrote: > Complaints from whom? Oracle rejects these, and PostgreSQL generally also > rejects these dates/times in other contexts. I think this should be > rejected. =46rom folks who hypothetically rely on the existing zeroed inputs. :) Perhaps it's a far-fetched argument, and just to be clear I would not really object to a change of behavior on HEAD for v20, just to see where it goes in 2027. -- Michael --5lKOtOPzdsJ8112n Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmnulScACgkQnvQgOdby QH3sSRAAin8C6YKK43OJgCuE3Ac5Rt8muMkI2fRXtF04YSZEPSUb2ySqgn3immqq XimG+irkpFn/5aTQxfb9rgfiS9w2Q89PO+72LEL3hp0AGHSrgwbrbshGiCm4Vn/0 uK2v+1XbODE0AWPffLGAnTBM/8wTVhRAg3i6a1e4mfj6cQGEA0MvLym+EhCMHxz5 blad9WveHCwqbfJoPNwYL7rEjl1YcWYxtbUSB43OEAbHkp0+cgjJ+V/+NKpWj4YT bLoswtgm6kYH+n1GUjFDzHEvx3W8qs003opEatiFdgwAkAq2AtmacjtHYQ/ydWmZ 06pHM919Zg9hhxmeIcrXUrnfW7sfCbBkICMy9m1IFNDR8ei0189hXwrm3EXW1DcJ bIFsdqp8Ph0LMRKm784+yB2bOVDN0olDRN3JvfGtZmSndEPeeA3PHrot4DDV6fC7 VGxwHxt7EjLANy80Jy50MQ4G09BoZ7jnkUbr78OPl3eTh/PO2VLJkhGHgUzkGJ18 OIYOxtDm8EOwK1ZRZRgG38n9yOv5teKAmu+jE2buOacY4JhbIRwCPXU/uZfS3cSl 16ar4YPtSQ/cLo9SPVawPfBe6Bx2WHr4vuCbm3hnHfLjke4cyzJ7CDQsnSIaTDHF l/Cl2Vg6DKVY1dZooMACiYOu58hkxwmTlxhID7zM0GHFDyseRw0= =tiOf -----END PGP SIGNATURE----- --5lKOtOPzdsJ8112n--