[SQL] How to get localized to_char(DATE) output

Hi, I'm trying to get the output of the to_char(date, text) method in German but I can't get it to work: My understanding is, that I need to set lc_time for the session in order to change the language used by to_char(), but this does not seem to work for me: postgres=> select version();

Re: [SQL] How to get localized to_char(DATE) output

Thomas Kellerer writes: > I'm trying to get the output of the to_char(date, text) method in German but > I can't get it to work: I think you need 'TMMon' to get a localized month name. regards, tom lane -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To m

Re: [SQL] How to get localized to_char(DATE) output

Tom Lane, 06.05.2010 00:51: Thomas Kellerer writes: I'm trying to get the output of the to_char(date, text) method in German but I can't get it to work: I think you need 'TMMon' to get a localized month name. regards, tom lane Ah! Silly me. Now that you write this