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

Edit
ID 6792
Title to_date()/to_timestamp() silently accept month=0 and day=0
CI (CFBot) Summary
Stats (from CFBot) Patch version: v2, Patch count: 1, First patch: +30−0, All patches: +30−0
Tags Bugfix
Created 2026-05-20 10:56:05
Last modified 2026-05-20 10:56:05 (4 hours ago)
Latest email 2026-04-30 22:57:22 (2 weeks ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version stable
Authors Ayush Tiwari (aytiwari)
Reviewers Become reviewer
Committer
Links
Emails
to_date()/to_timestamp() silently accept month=0 and day=0
First at 2026-04-22 14:18:00 by Ayush Tiwari <ayushtiwari.slg01 at gmail.com>
Latest at 2026-04-30 22:57:22 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v2-0001-Add-regression-tests-for-zero-month-day-handling-.patch) at 2026-04-24 12:44:04 from Daniel Gustafsson <daniel at yesql.se>
    Attachment (v2-0001-Add-regression-tests-for-zero-month-day-handling-.patch) at 2026-04-24 12:44:04 from Daniel Gustafsson <daniel at yesql.se> (Patch: Yes)
    Attachment (0001-Add-regression-tests-for-to_date-to_timestamp-zero-m.patch) at 2026-04-24 09:13:14 from Ayush Tiwari <ayushtiwari.slg01 at gmail.com> (Patch: Yes)
History
When Who What
2026-05-20 10:56:05 Ayush Tiwari (aytiwari) Attached mail thread CAJTYsWWNfF+hMpbsTDF8NMr+AuqoDfNxR=oHUZm7xqGP+dJ9rA@mail.gmail.com
2026-05-20 10:56:05 Ayush Tiwari (aytiwari) Created patch record
Edit