Request a Demo
Home   >   mailing lists

Re: to_date()/to_timestamp() silently accept month=0 and day=0 - Mailing list pgsql-bugs

From Ayush Tiwari
Subject Re: to_date()/to_timestamp() silently accept month=0 and day=0
Date
Msg-id CAJTYsWV1wEuv2ZbBHt4BQ2O4-Na6JdxSU3b--GFzs-j5cG_pVA@mail.gmail.com
Whole thread
In response to Re: to_date()/to_timestamp() silently accept month=0 and day=0  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: to_date()/to_timestamp() silently accept month=0 and day=0
List pgsql-bugs
Tree view
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 

pgsql-bugs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0
Next
From: Oleg Gurev
Date:
Subject: [BUG] Windows Server 2019 build fail