Re: lc_time not working?

On 01/07/2013 07:56 AM, Tom Lane wrote:
> Adrian Klaver <adrian.klaver@gmail.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.klaver@gmail.com