Re: lc_time and localized dates

Zdenek Kotala wrote:

> Please, Day names does not have capitalized first letter in Czech
> language. We have "pondeli" as a Monday. If locale does not do that it
> is probably intention :-).
>
Hmmm... I don't know about that. I do it that way 'cause I'm concerned
about some locales that don't capitalize (see above). In my head,
(i) 'TMMonth' is February, Fevereiro, Febrero, Únor;
(ii) 'TMmonth' is february, fevereiro, febrero, únor;
(iii) 'TMMONTH' is FEBRUARY, FEVEREIRO, FEBRERO, ÚNOR.

How would we handle that case? Is it wrong to write "Únor"?

euler=# set lc_time to 'cs_CZ';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
        to_char
---------------------
  Pondìlí Po úno únor
(1 registro)

euler=# set lc_time to 'es_ES';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
         to_char
-----------------------
  lunes lun feb febrero
(1 registro)

euler=# set lc_time to 'fr_FR';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
         to_char
-----------------------
  lundi lun fév février
(1 registro)

euler=# set lc_time to 'it_IT';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
          to_char
-------------------------
  lunedì lun feb febbraio
(1 registro)

euler=# set lc_time to 'hu_HU';
SET
euler=# select to_char(now(), 'TMDay TMDy TMMon TMMonth');
        to_char
----------------------
  hétfõ h febr február
(1 registro)


--
   Euler Taveira de Oliveira
   http://www.timbira.com/