Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

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.



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group