Skip site navigation (1) Skip section navigation (2)

Re: lc_time and localized dates

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: lc_time and localized dates
Date: 2008-02-25 23:09:12
Message-ID: 47C34A98.7050102@timbira.com (view raw or flat)
Thread:
Lists: pgsql-patches
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/

In response to

Responses

pgsql-patches by date

Next:From: Florian G. PflugDate: 2008-02-25 23:20:12
Subject: Re: Fix pgstatindex using for large indexes
Previous:From: Neil ConwayDate: 2008-02-25 21:32:10
Subject: SRF memory leaks

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group