BUG #7796: LC_MESSAGES

Started by Nonameover 13 years ago2 messagesbugs
Jump to latest
#1Noname
funnybonn40@yahoo.com

The following bug has been logged on the website:

Bug reference: 7796
Logged by: Michael
Email address: funnybonn40@yahoo.com
PostgreSQL version: 9.1.7
Operating system: Windows 7
Description:

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 "

Best regards

Michael

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Noname (#1)
Re: BUG #7796: LC_MESSAGES

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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs