From: | "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> |
---|---|
To: | "jcrada" <jcrada(at)gmail(dot)com> |
Cc: | <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: lc_messages to_char('2007/01/01'::date,'TMMonth') does not work. |
Date: | 2008-03-18 10:36:27 |
Message-ID: | 47DF9B2B.2020200@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Chan, Keith (LESA IT) | 2008-03-18 15:52:26 | Re: BUG #4041: error in Application Stack Builder |
Previous Message | Dave Page | 2008-03-18 09:09:38 | Re: BUG #3983: pgxs files still missing in win32 install (8.3.1) |