public inbox for [email protected]  

help / color / mirror / Atom feed
From: Ayush Tiwari <[email protected]>
To: Michael Paquier <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: Tom Lane <[email protected]>
Cc: Daniel Gustafsson <[email protected]>
Cc: [email protected]
Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0
Date: Thu, 30 Apr 2026 19:44:24 +0530
Message-ID: <CAJTYsWU0_CxphN=dfY=DCMO=n2yg4h2wvt8W=wP30zAhxoiK6A@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJTYsWWNfF+hMpbsTDF8NMr+AuqoDfNxR=oHUZm7xqGP+dJ9rA@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

Hi,


On Mon, 27 Apr 2026 at 04:13, Michael Paquier <[email protected]> wrote:

> On Fri, Apr 24, 2026 at 05:41:50PM +0200, Peter Eisentraut wrote:
> > Complaints from whom?  Oracle rejects these, and PostgreSQL generally
> also
> > rejects these dates/times in other contexts.  I think this should be
> > rejected.
>
> From folks who hypothetically rely on the existing zeroed inputs.  :)
> Perhaps it's a far-fetched argument, and just to be clear I would not
> really object to a change of behavior on HEAD for v20, just to see
> where it goes in 2027.
>

I'll add this to the commitfest, so that we can circle back on this
once v20 development starts.

I think parallely we can commit Daniel's v2 patch, since
that correctly documents what Postgres has right now, and we'll
know what exactly to change if we decide to go the other way.

Regards,
Ayush


reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: to_date()/to_timestamp() silently accept month=0 and day=0
  In-Reply-To: <CAJTYsWU0_CxphN=dfY=DCMO=n2yg4h2wvt8W=wP30zAhxoiK6A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox