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

From: Daniel Gustafsson <daniel(at)yesql(dot)se>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0
Date: 2026-04-24 08:12:31
Message-ID: B96867CD-3533-40BA-AE09-43DB2CA5DC48@yesql.se
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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?

--
Daniel Gustafsson

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Ayush Tiwari 2026-04-24 08:16:56 Re: to_date()/to_timestamp() silently accept month=0 and day=0
Previous Message Daniel Gustafsson 2026-04-24 08:11:04 Re: BUG #19457: RE: pgp_sym_encrypt silently accepts non-FIPS ciphers (bf, cast5, 3des) when OpenSSL is in FIPS mod