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
