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 hru6l8$567$1@dough.gmane.org
Whole thread Raw
In response to Re: How to get localized to_char(DATE) output  (Jasen Betts <jasen@xnet.co.nz>)
Responses Re: How to get localized to_char(DATE) output  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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 POSIXish)
>
> Looks like "locale -a" does it on linux, that may be worth a try.
>
> "de_DE" is the locale for German as used in Germany.
>
>
>
Thanks for the answer. Is there a way to get this information from within a SQL statement?

Regards
Thomas

pgsql-sql by date:

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