Re: missing possibility to use alternative translated month names in to_char function - Mailing list pgsql-hackers

út 11. 8. 2026 v 17:06 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:

Hi

My customer reported an interesting issue. He needs translated month name, and then he use

to_char(current_date, 'tmmonth');

Unfortunately, glibc returns nouns in the genitive case instead of the nominative case.

This is a glibc feature from the 2.28 release. Genitive case makes sense, when the result holds a day, but without it, it is messy.

glibc has alternative month names, that can be taken by usage placeholder '%OB'  of function strftime. https://pubs.opengroup.org/onlinepubs/9799919799/basedefs/V1_chap07.html - see alt_mon.

Can we enhance prefixes (maybe tmo) to be possible to use alternative names?

example:

pavel@nemesis:~/src/orafce$ date +'%B'
srpna
pavel@nemesis:~/src/orafce$ date +'%OB'
srpen
pavel@nemesis:~/src/orafce$ LANG=C date +'%OB'
August

 

Regards

Pavel