lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.
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.
When will it be back? I don't want to rewrite the whole application :
(.
Thanks,
Juan Rada.
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