Re: BUG #7796: LC_MESSAGES

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: funnybonn40(at)yahoo(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7796: LC_MESSAGES
Date: 2013-01-30 14:28:43
Message-ID: 51092E1B.3040907@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 1/6/13 11:17 PM, funnybonn40(at)yahoo(dot)com wrote:
> Hello, my engish is not so good, but i try to describe what seems not to
> work. Could it be, that the LC_MESSANGES for months and days like
>
> Months
> ------
> Janary=Januar
> February=Februar
>
> Days
> ----
> monday=Montag
> Thursdat=Dienstag
>
>
> 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
──────────
MITTWOCH

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-01-30 17:31:13 Re: BUG #7838: pg_dump major bug
Previous Message Pavan Deolasee 2013-01-30 08:22:27 Re: BUG #7827: Postgresql Porblem