Re: lc_time not working?

On 01/07/2013 07:56 AM, Tom Lane wrote:
> Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
>> On 01/07/2013 06:45 AM, J. Hondius wrote:
>>> I'm not getting my PostgreSQL 9.2 to return the correct lc_time
>
>>> openwave001=# select set_config('lc_time', 'nl_NL', true);
>
>> When you use true it only applies for that transaction.
>
> But he has the same setting in postgresql.conf anyway. I think the real
> mistake is here:
>
>>> openwave001=# select to_char(now(),'dd month day yyyy');
>
> To get localized month/day names you need to add the TM prefix to the
> field, ie this should be
>
> select to_char(now(),'dd tmmonth tmday yyyy');

Aargh, missed that.

>
> regards, tom lane
>
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com