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

From: jcrada <jcrada(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.
Date: 2008-03-18 02:22:16
Message-ID: c630d806-6bb1-460e-af99-3c4410b42e0e@q78g2000hsh.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2008-03-18 08:27:56 Re: BUG #4041: error in Application Stack Builder
Previous Message Alvaro Herrera 2008-03-18 00:47:49 Re: BUG #3983: pgxs files still missing in win32 install (8.3.1)