to_date()/to_timestamp() silently truncate 4+-digit day-of-year input to the first three digits

Edit
ID 7411
Title to_date()/to_timestamp() silently truncate 4+-digit day-of-year input to the first three digits
CI (CFBot) Summary
Stats (from CFBot) Patch count: 1, First patch: +123−5, All patches: +123−5
Tags Bugfix
Created 2026-10-08 10:46:21
Last modified 2026-10-08 10:46:21 (58 minutes ago)
Latest email 2026-09-09 04:31:58 (4 weeks ago)
Status
PG20-3 (2026-11-01 – 2026-11-30): Needs review
Target version
Authors Andrey Rachitskiy (a.rachitskiy)
Reviewers Become reviewer
Committer
Links
Emails
BUG #19650: to_date()/to_timestamp() silently truncate 4+-digit day-of-year input to the first three digits
First at 2026-09-03 06:45:25 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2026-09-09 04:31:58 by Clemenza Zhang <zxlmgsps2 at gmail.com>
Latest attachment (0001-Reject-out-of-range-to_date-to_timestamp-template.patch) at 2026-09-03 15:29:28 from Andrey Rachitskiy <pl0h0yp1 at gmail.com>
    Attachment (0001-Reject-out-of-range-to_date-to_timestamp-template.patch) at 2026-09-03 15:29:28 from Andrey Rachitskiy <pl0h0yp1 at gmail.com> (Patch: No)
History
When Who What
2026-10-08 10:46:21 Andrey Rachitskiy (a.rachitskiy) Attached mail thread 19650-d7ea430084cdc44a@postgresql.org
2026-10-08 10:46:21 Andrey Rachitskiy (a.rachitskiy) Created patch record
Edit