Thanks very much Tom and Adrian.
Solved. I will RTFM better next time.
Thanks again, Joek
Adrian Klaver schreef:
> 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
>>
>>
>
>