Postgres Pro
Downloads
Home   >   mailing lists

Re: How to get localized to_char(DATE) output - Mailing list pgsql-sql

From Thomas Kellerer
Subject Re: How to get localized to_char(DATE) output
Date
Msg-id hrtod0$hom$1@dough.gmane.org
Whole thread Raw
In response to Re: How to get localized to_char(DATE) output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
Tom Lane, 06.05.2010 00:51:
> Thomas Kellerer<spam_eater@gmx.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to get localized to_char(DATE) output
Next
From: Jasen Betts
Date:
Subject: Re: How to get localized to_char(DATE) output