MIME-Version: 1.0
References: <CAJTYsWWNfF+hMpbsTDF8NMr+AuqoDfNxR=oHUZm7xqGP+dJ9rA@mail.gmail.com>
 <aenQ37wBgKqZb7a8@paquier.xyz> <FE1D12FF-7E5D-4ED0-A59F-BEA6DEF7EE2C@yesql.se>
 <1444609.1776958814@sss.pgh.pa.us> <CAJTYsWUJFHhqiGD+6vw6m0ELqjajoKev2UutFUMB2uQDjm6+TA@mail.gmail.com>
 <aeqZukF8X29eWtqy@paquier.xyz> <B96867CD-3533-40BA-AE09-43DB2CA5DC48@yesql.se>
In-Reply-To: <B96867CD-3533-40BA-AE09-43DB2CA5DC48@yesql.se>
From: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Date: Fri, 24 Apr 2026 13:46:56 +0530
Message-ID: <CAJTYsWV1wEuv2ZbBHt4BQ2O4-Na6JdxSU3b--GFzs-j5cG_pVA@mail.gmail.com>
Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0
To: Daniel Gustafsson <daniel@yesql.se>
Cc: Michael Paquier <michael@paquier.xyz>, Tom Lane <tgl@sss.pgh.pa.us>, 
	pgsql-bugs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000013f550650306446"
Archived-At: <https://www.postgresql.org/message-id/CAJTYsWV1wEuv2ZbBHt4BQ2O4-Na6JdxSU3b--GFzs-j5cG_pVA%40mail.gmail.com>
Precedence: bulk

--000000000000013f550650306446
Content-Type: text/plain; charset="UTF-8"

Hi,

On Fri, 24 Apr 2026 at 13:42, Daniel Gustafsson <daniel@yesql.se> wrote:

> > On 24 Apr 2026, at 00:14, Michael Paquier <michael@paquier.xyz> wrote:
> >
> > On Thu, Apr 23, 2026 at 10:06:41PM +0530, Ayush Tiwari wrote:
> >> If we are not going to change the behaviour, imo, we should
> >> atleast add a test case to depict this scenario and comment
> >> that says this is expected behaviour according to the community.
> >
> > Yes, we could close the gap with some tests, at least.
>
> +1. Do you want to work on this Ayush?
>

Yes, I'll send a patch with test case today.

Regards,
Ayush

--000000000000013f550650306446
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><br><div class=3D"gmail_quote gmail_quote_co=
ntainer"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 24 Apr 2026 at 13:42=
, Daniel Gustafsson &lt;<a href=3D"mailto:daniel@yesql.se">daniel@yesql.se<=
/a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">&=
gt; On 24 Apr 2026, at 00:14, Michael Paquier &lt;<a href=3D"mailto:michael=
@paquier.xyz" target=3D"_blank">michael@paquier.xyz</a>&gt; wrote:<br>
&gt; <br>
&gt; On Thu, Apr 23, 2026 at 10:06:41PM +0530, Ayush Tiwari wrote:<br>
&gt;&gt; If we are not going to change the behaviour, imo, we should<br>
&gt;&gt; atleast add a test case to depict this scenario and comment<br>
&gt;&gt; that says this is expected behaviour according to the community.<b=
r>
&gt; <br>
&gt; Yes, we could close the gap with some tests, at least.<br>
<br>
+1. Do you want to work on this Ayush?<br></blockquote><div><br></div><div>=
Yes, I&#39;ll send a patch with test case today.<br><br>Regards,<br>Ayush=
=C2=A0</div></div></div>

--000000000000013f550650306446--