From: | Vincent Moreau <vincentneko(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | [PATCH] Add a new pattern for zero-based months for Date/Time Formatting |
Date: | 2025-03-24 10:27:05 |
Message-ID: | CAHZj6Fjf0av_5QRnqtj+RuKKMihK9s5grnYkt7Q=pgMFnC_R_w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I came across date information from an external data source where the
month number is zero-based (January = 0, December = 11) and found that
I couldn't process it directly using the TO_DATE function.
This patch introduces a new pattern (MZ) for handling zero-based
months in Date/Time Formatting.
## Example
SELECT to_date('01012025', 'DDMZYYYY');
to_date
------------
2025-02-01
## Implementation notes
This is my first patch submission. I have tried to follow the
guidelines from various documents, but please let me know if anything
is missing or not aligned with expectations. My apologies in advance
for any oversights.
Thanks,
Vincent Moreau
Attachment | Content-Type | Size |
---|---|---|
Add-mz-pattern.patch | application/octet-stream | 4.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Álvaro Herrera | 2025-03-24 10:37:20 | Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN |
Previous Message | Shubham Khanna | 2025-03-24 10:26:20 | Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. |