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