Re: missing possibility to use alternative translated month names in to_char function

út 11. 8. 2026 v 17:06 odesílatel Pavel Stehule <pavel(dot)stehule(at)gmail(dot)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(at)nemesis:~/src/orafce$ date +'%B'
srpna
pavel(at)nemesis:~/src/orafce$ date +'%OB'
srpen
pavel(at)nemesis:~/src/orafce$ LANG=C date +'%OB'
August

>
> Regards
>
> Pavel
>
>
>
>
>
>