Обсуждение: 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