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

2010-05-06 Thread Thomas Kellerer
Tom Lane, 06.05.2010 16:22: Looks like "locale -a" does it on linux, that may be worth a try. Thanks for the answer. Is there a way to get this information from within a SQL statement? No. Postgres doesn't know anything about that. "locale -a" should work on pretty much any Unix-ish syste

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

2010-05-06 Thread Tom Lane
Thomas Kellerer writes: > Jasen Betts, 06.05.2010 11:57: >>> Is there a way to get a list of allowed values for lc_time for a specific >>> installation? >> Looks like "locale -a" does it on linux, that may be worth a try. > Thanks for the answer. Is there a way to get this information from with

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

2010-05-06 Thread Thomas Kellerer
Jasen Betts, 06.05.2010 11:57: The manual says the value for lc_time is OS dependent and indeed "set lc_time = 'German'" does not work on Solaris. Is there a way to get a list of allowed values for lc_time for a specific installation? "man -k locale" would be my starting point (for anything

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

2010-05-06 Thread Jasen Betts
On 2010-05-06, Thomas Kellerer wrote: > 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. >> >> reg

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

2010-05-05 Thread Thomas Kellerer
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

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

2010-05-05 Thread Tom Lane
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

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

2010-05-05 Thread Thomas Kellerer
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();