Re: How to get localized to_char(DATE) output

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to get localized to_char(DATE) output
Date: 2010-05-06 06:42:40
Message-ID: hrtod0$hom$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Tom Lane, 06.05.2010 00:51:
> Thomas Kellerer<spam_eater(at)gmx(dot)net> 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 I can see it in the manual ;)

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?

Thanks for your help

Thomas

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jasen Betts 2010-05-06 09:57:34 Re: How to get localized to_char(DATE) output
Previous Message Tom Lane 2010-05-05 22:51:26 Re: How to get localized to_char(DATE) output