Re: to_date()/to_timestamp() silently accept month=0 and day=0

Hi,

On Fri, 24 Apr 2026 at 13:46, Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
wrote:

> Hi,
>
> On Fri, 24 Apr 2026 at 13:42, Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
>
>> > On 24 Apr 2026, at 00:14, Michael Paquier <michael(at)paquier(dot)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