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>
 <CAJTYsWV1wEuv2ZbBHt4BQ2O4-Na6JdxSU3b--GFzs-j5cG_pVA@mail.gmail.com>
In-Reply-To: <CAJTYsWV1wEuv2ZbBHt4BQ2O4-Na6JdxSU3b--GFzs-j5cG_pVA@mail.gmail.com>
From: Ayush Tiwari <ayushtiwari.slg01@gmail.com>
Date: Fri, 24 Apr 2026 14:43:14 +0530
Message-ID: <CAJTYsWVEk5vdy8of2DCWzDNJgHUNL0p0Dt6b1zkgmvmNo3ht6w@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/mixed; boundary="0000000000006630060650312d57"
Archived-At: <https://www.postgresql.org/message-id/CAJTYsWVEk5vdy8of2DCWzDNJgHUNL0p0Dt6b1zkgmvmNo3ht6w%40mail.gmail.com>
Precedence: bulk

--0000000000006630060650312d57
Content-Type: multipart/alternative; boundary="0000000000006630050650312d55"

--0000000000006630050650312d55
Content-Type: text/plain; charset="UTF-8"

Hi,

On Fri, 24 Apr 2026 at 13:46, Ayush Tiwari <ayushtiwari.slg01@gmail.com>
wrote:

> 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.
>
>
Attached patch, please review.

Regards,
Ayush

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

<div dir=3D"ltr"><div dir=3D"ltr">Hi,</div><br><div class=3D"gmail_quote gm=
ail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, 24 Apr 2=
026 at 13:46, Ayush Tiwari &lt;<a href=3D"mailto:ayushtiwari.slg01@gmail.co=
m">ayushtiwari.slg01@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D=
"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2=
04,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi,</div><br><div class=
=3D"gmail_quote"><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" target=
=3D"_blank">daniel@yesql.se</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 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></div></div></div><=
/blockquote><div><br></div><div>Attached patch, please review.<br><br>Regar=
ds,<br>Ayush=C2=A0</div></div></div>

--0000000000006630050650312d55--
--0000000000006630060650312d57
Content-Type: application/octet-stream; 
	name="0001-Add-regression-tests-for-to_date-to_timestamp-zero-m.patch"
Content-Disposition: attachment; 
	filename="0001-Add-regression-tests-for-to_date-to_timestamp-zero-m.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mocoyq250>
X-Attachment-Id: f_mocoyq250

RnJvbSAzOGQ5YTFiNTgwZjMwODNhZGU1ZjE4YTQyNzI5ZTFiOTgyYWQ5YTRjIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBBeXVzaCBUaXdhcmkgPGF5dGl3YXJpQG1pY3Jvc29mdC5jb20+
CkRhdGU6IEZyaSwgMjQgQXByIDIwMjYgMTQ6Mzg6MDAgKzA1MzAKU3ViamVjdDogW1BBVENIXSBB
ZGQgcmVncmVzc2lvbiB0ZXN0cyBmb3IgdG9fZGF0ZSgpL3RvX3RpbWVzdGFtcCgpIHplcm8KIG1v
bnRoL2RheSBoYW5kbGluZwoKWmVybyB2YWx1ZXMgZm9yIG1vbnRoIGFuZCBkYXkgZmllbGRzIGlu
IHRvX2RhdGUoKSBhbmQgdG9fdGltZXN0YW1wKCkKZm9ybWF0IHN0cmluZ3MgYXJlIGludGVudGlv
bmFsbHkgdHJlYXRlZCBhcyBtaXNzaW5nIGRhdGEgYW5kIGRlZmF1bHQKdG8gMSAoSmFudWFyeSAv
IGRheS1vZi1tb250aCAxKSwgbWF0Y2hpbmcgdGhlIFpFUk9fdG0oKSBpbml0aWFsaXphdGlvbgpp
biBmb3JtYXR0aW5nLmMuICBBZGQgdGVzdHMgZG9jdW1lbnRpbmcgdGhpcyBsb25nLXN0YW5kaW5n
IGJlaGF2aW9yLgoKUmVwb3J0ZWQtYnk6IEF5dXNoIFRpd2FyaSA8YXl1c2h0aXdhcmkuc2xnMDFA
Z21haWwuY29tPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSlRZc1dXTmZGK2hN
cGJzVERGOE5NcitBdXFvRGZOeFI9b0hVWm03eHFHUCtkSjlyQUBtYWlsLmdtYWlsLmNvbQotLS0K
IHNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaG9yb2xvZ3kub3V0IHwgMzMgKysrKysrKysrKysr
KysrKysrKysrKysrKysKIHNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2hvcm9sb2d5LnNxbCAgICAgIHwg
IDkgKysrKysrKwogMiBmaWxlcyBjaGFuZ2VkLCA0MiBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0
IGEvc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9ob3JvbG9neS5vdXQgYi9zcmMvdGVzdC9yZWdy
ZXNzL2V4cGVjdGVkL2hvcm9sb2d5Lm91dAppbmRleCAzMmNmNjJiNjc0MS4uNGJiNTllNjk1NDUg
MTAwNjQ0Ci0tLSBhL3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaG9yb2xvZ3kub3V0CisrKyBi
L3NyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvaG9yb2xvZ3kub3V0CkBAIC0zNzc4LDYgKzM3Nzgs
MzkgQEAgU0VMRUNUIHRvX3RpbWVzdGFtcCgnNjEzNTY2NzU4JywgJ1cnKTsKIEVSUk9SOiAgZGF0
ZS90aW1lIGZpZWxkIHZhbHVlIG91dCBvZiByYW5nZTogIjYxMzU2Njc1OCIKIFNFTEVDVCB0b190
aW1lc3RhbXAoJzIwMjQgNjEzNTY2NzU4IDEnLCAnWVlZWSBXVyBEJyk7CiBFUlJPUjogIGRhdGUv
dGltZSBmaWVsZCB2YWx1ZSBvdXQgb2YgcmFuZ2U6ICIyMDI0IDYxMzU2Njc1OCAxIgorLS0gWmVy
byBtb250aC9kYXkgdmFsdWVzIGFyZSB0cmVhdGVkIGFzIG1pc3NpbmcgZGF0YSBhbmQgZGVmYXVs
dCB0byAxCistLSAoc2VlIFpFUk9fdG0oKSBpbiBmb3JtYXR0aW5nLmMgd2hpY2ggaW5pdGlhbGl6
ZXMgdG1fbW9uID0gdG1fbWRheSA9IDEsCistLSBhbmQgZG9fdG9fdGltZXN0YW1wKCkgd2hpY2gg
b25seSBvdmVyd3JpdGVzIHRoZW0gZm9yIG5vbi16ZXJvIHBhcnNlZCB2YWx1ZXMpCitTRUxFQ1Qg
dG9fZGF0ZSgnMjAyNC0wMC0xNScsICdZWVlZLU1NLUREJyk7ICAgICAgLS0gbW9udGggMCAtPiBk
ZWZhdWx0cyB0byBKYW51YXJ5CisgIHRvX2RhdGUgICAKKy0tLS0tLS0tLS0tLQorIDAxLTE1LTIw
MjQKKygxIHJvdykKKworU0VMRUNUIHRvX2RhdGUoJzIwMjQtMDEtMDAnLCAnWVlZWS1NTS1ERCcp
OyAgICAgIC0tIGRheSAwIC0+IGRlZmF1bHRzIHRvIGRheSAxCisgIHRvX2RhdGUgICAKKy0tLS0t
LS0tLS0tLQorIDAxLTAxLTIwMjQKKygxIHJvdykKKworU0VMRUNUIHRvX2RhdGUoJzIwMjQtMDAt
MDAnLCAnWVlZWS1NTS1ERCcpOyAgICAgIC0tIGJvdGggemVybyAtPiBKYW4gMQorICB0b19kYXRl
ICAgCistLS0tLS0tLS0tLS0KKyAwMS0wMS0yMDI0CisoMSByb3cpCisKK1NFTEVDVCB0b190aW1l
c3RhbXAoJzIwMjQtMDAtMTUnLCAnWVlZWS1NTS1ERCcpOyAtLSBzYW1lIGJlaGF2aW9yIGZvciB0
b190aW1lc3RhbXAKKyAgICAgICAgIHRvX3RpbWVzdGFtcCAgICAgICAgIAorLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tCisgTW9uIEphbiAxNSAwMDowMDowMCAyMDI0IFBTVAorKDEgcm93
KQorCitTRUxFQ1QgdG9fdGltZXN0YW1wKCcyMDI0LTAxLTAwJywgJ1lZWVktTU0tREQnKTsKKyAg
ICAgICAgIHRvX3RpbWVzdGFtcCAgICAgICAgIAorLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tCisgTW9uIEphbiAwMSAwMDowMDowMCAyMDI0IFBTVAorKDEgcm93KQorCiBTRUxFQ1QgdG9f
ZGF0ZSgnMjAxNi0xMy0xMCcsICdZWVlZLU1NLUREJyk7CiBFUlJPUjogIGRhdGUvdGltZSBmaWVs
ZCB2YWx1ZSBvdXQgb2YgcmFuZ2U6ICIyMDE2LTEzLTEwIgogU0VMRUNUIHRvX2RhdGUoJzIwMTYt
MDItMzAnLCAnWVlZWS1NTS1ERCcpOwpkaWZmIC0tZ2l0IGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwv
aG9yb2xvZ3kuc3FsIGIvc3JjL3Rlc3QvcmVncmVzcy9zcWwvaG9yb2xvZ3kuc3FsCmluZGV4IDg5
NzgyNDlhNWRjLi40OGJiZjE0YTIxMCAxMDA2NDQKLS0tIGEvc3JjL3Rlc3QvcmVncmVzcy9zcWwv
aG9yb2xvZ3kuc3FsCisrKyBiL3NyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2hvcm9sb2d5LnNxbApAQCAt
NjYwLDYgKzY2MCwxNSBAQCBTRUxFQ1QgdG9fdGltZXN0YW1wKCcxMDAwMDAwMDAwLDk5OScsICdZ
LFlZWScpOwogU0VMRUNUIHRvX3RpbWVzdGFtcCgnMC4tMjE0NzQ4MzY0OCcsICdTUy5NUycpOwog
U0VMRUNUIHRvX3RpbWVzdGFtcCgnNjEzNTY2NzU4JywgJ1cnKTsKIFNFTEVDVCB0b190aW1lc3Rh
bXAoJzIwMjQgNjEzNTY2NzU4IDEnLCAnWVlZWSBXVyBEJyk7CistLSBaZXJvIG1vbnRoL2RheSB2
YWx1ZXMgYXJlIHRyZWF0ZWQgYXMgbWlzc2luZyBkYXRhIGFuZCBkZWZhdWx0IHRvIDEKKy0tIChz
ZWUgWkVST190bSgpIGluIGZvcm1hdHRpbmcuYyB3aGljaCBpbml0aWFsaXplcyB0bV9tb24gPSB0
bV9tZGF5ID0gMSwKKy0tIGFuZCBkb190b190aW1lc3RhbXAoKSB3aGljaCBvbmx5IG92ZXJ3cml0
ZXMgdGhlbSBmb3Igbm9uLXplcm8gcGFyc2VkIHZhbHVlcykKK1NFTEVDVCB0b19kYXRlKCcyMDI0
LTAwLTE1JywgJ1lZWVktTU0tREQnKTsgICAgICAtLSBtb250aCAwIC0+IGRlZmF1bHRzIHRvIEph
bnVhcnkKK1NFTEVDVCB0b19kYXRlKCcyMDI0LTAxLTAwJywgJ1lZWVktTU0tREQnKTsgICAgICAt
LSBkYXkgMCAtPiBkZWZhdWx0cyB0byBkYXkgMQorU0VMRUNUIHRvX2RhdGUoJzIwMjQtMDAtMDAn
LCAnWVlZWS1NTS1ERCcpOyAgICAgIC0tIGJvdGggemVybyAtPiBKYW4gMQorU0VMRUNUIHRvX3Rp
bWVzdGFtcCgnMjAyNC0wMC0xNScsICdZWVlZLU1NLUREJyk7IC0tIHNhbWUgYmVoYXZpb3IgZm9y
IHRvX3RpbWVzdGFtcAorU0VMRUNUIHRvX3RpbWVzdGFtcCgnMjAyNC0wMS0wMCcsICdZWVlZLU1N
LUREJyk7CisKIFNFTEVDVCB0b19kYXRlKCcyMDE2LTEzLTEwJywgJ1lZWVktTU0tREQnKTsKIFNF
TEVDVCB0b19kYXRlKCcyMDE2LTAyLTMwJywgJ1lZWVktTU0tREQnKTsKIFNFTEVDVCB0b19kYXRl
KCcyMDE2LTAyLTI5JywgJ1lZWVktTU0tREQnKTsgIC0tIG9rCi0tIAoyLjM0LjEKCg==
--0000000000006630060650312d57--