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

From Tom Lane
Subject Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting
Date
Msg-id 1616069.1743003744@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting  (Christoph Berg <myon@debian.org>)
List pgsql-hackers
Christoph Berg <myon@debian.org> 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 friends.

FWIW, I agree completely with Peter's objections, and here's one more:
the last thing the world needs is yet another way in which datetime
strings can be ambiguous.  I think the right answer to the OP's
problem is to push back on the data source.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: vacuum_truncate configuration parameter and isset_offset
Next
From: Vladlen Popolitov
Date:
Subject: Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS)