Hi All, please advise I'm not getting my PostgreSQL 9.2 to return the correct lc_time See psql output below. lc_monetary and the lc's do work correctly postgresql.conf is set to lc_time = 'nl_NL' the output of locale -a includes nl_NL [root@d01 ~]# psql db user psql (9.2.1) Type "help" for help. openwave001=# select set_config('lc_time', 'nl_NL', true); set_config ------------ nl_NL (1 row) openwave001=# select to_char(now(),'dd month day yyyy'); to_char ----------------------------- 07 january monday 2013 (1 row) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general