Adrian Klaver <adrian.kla...@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');

                        regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to