On 1/6/13 11:17 PM, funnybon...@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