Search Postgresql Archives

Re: lc_time not working? Solved.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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






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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux