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

Christoph Berg writes: > Re: Peter Eisentraut >> Moreover, if there are zero-based months, why not zero-based days, >> or any of the other fields? > I would suspect this is coming from C's struct tm where tm_mon is > 0..11 and all other fields being "normal". Used by asctime(), gmtime() > and fri

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

Re: Peter Eisentraut > Moreover, if there are zero-based months, why not zero-based days, > or any of the other fields? I would suspect this is coming from C's struct tm where tm_mon is 0..11 and all other fields being "normal". Used by asctime(), gmtime() and friends. Christoph

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

On 24.03.25 11:45, Vincent Moreau wrote: 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 ze