On Wed, Oct 6, 2021 at 11:09 AM Magnus Holmgren <magnus.holmg...@millnet.se> wrote:
> > There's just this tiny but seemingly obvious issue that I can't believe I > haven't noticed until now: to_date(now(), 'TMmonth') returns 'october' in > an > English locale (en_US.UTF-8 at least). Names of months and weekdays are > proper > nouns and as such *always* capitalized in English, so that seems wrong to > me. > > IMHO, the patterns of TO_CHAR() do as promised in the documentation [1]: MONTH full upper case month name (blank-padded to 9 chars) Month full capitalized month name (blank-padded to 9 chars) month full lower case month name (blank-padded to 9 chars) What you are proposing looks more like a new feature than a bug. [1] https://www.postgresql.org/docs/current/functions-formatting.html Regards, Juan José Santamaría Flecha
