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
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 |