Re: Allow to_date() and to_timestamp() to accept localized names

On 2020-01-24 19:01, Peter Eisentraut wrote:
> postgres=# select to_char(now(),'TMmonth');
> to_char
> ------------
> ιανουαρίου
> (1 row)
>
> which is the genitive of ιανουάριος. You use the genitive form for a
> date (24th of January) but the nominative otherwise. But the reverse
> mapping can only take one of these forms. So here
>
> select to_date('Ιανουαριος', 'TMMonth');
>
> fails, which is bad.

For the record, the correct form of that would appear to be

select to_date('Ιανουάριος', 'TMMonth');

with the accent. I had tried different variations of that and they all
failed.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services