[PATCH] Add a new pattern for zero-based months for Date/Time Formatting

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

Browse pgsql-hackers by date

  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.