Re: lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.

jcrada wrote:
> Hi, I'm having trouble displaying date names in other locales:
>
> central=# show lc_messages;
>    lc_messages
> -----------------
>  fr_FR.ISO8859-1
> (1 row)
>
> central=# select to_char('2007/01/01'::date,'TMMonth');
>  to_char
> ---------
>  January
> (1 row)
>
> This result is not the expected result, since my locale is fr_FR I
> expect (as older versions of psql) to return Janvier instead. The same
> applies when lc_messages = 'es_VE'.
> Localization support in dates using to_char(date,varchar) is gone.

Most likely, you're using a version compiled without Native Language
Support support (see --enable-nls configure option).

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com