Re: BUG #7796: LC_MESSAGES - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: BUG #7796: LC_MESSAGES
Date
Msg-id 51092E1B.3040907@gmx.net
Whole thread Raw
In response to BUG #7796: LC_MESSAGES  (funnybonn40@yahoo.com)
List pgsql-bugs
On 1/6/13 11:17 PM, funnybonn40@yahoo.com wrote:
> Hello, my engish is not so good, but i try to describe what seems not t=
o
> work. Could it be, that the LC_MESSANGES for months and days like=20
>=20
> Months
> ------
> Janary=3DJanuar
> February=3DFebruar
>=20
> Days
> ----
> monday=3DMontag
> Thursdat=3DDienstag
>=20
>=20
> not implemented for German? I execute this command:
> set datestyle to german
> But the result of following query is:
> select to_char(current_timestamp,'DAY');
> "MONDAY   "

You need to use the TM modifier to get translated results, and you need
to set lc_time, not lc_messages.

select to_char(current_timestamp,'TMDAY');
 to_char
=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=94=80=E2=
=94=80=E2=94=80
 MITTWOCH

pgsql-bugs by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: BUG #7827: Postgresql Porblem
Next
From: jan.mate@inf-it.com
Date:
Subject: BUG #7838: pg_dump major bug