Christoph Berg <m...@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