Re: lc_time and localized dates

Tom Lane wrote:

> But as Peter remarks nearby, this discussion is wasted anyway, because
> there is only one correct answer: whatever Oracle does with these
> cases is what to_char() should do.
>
My patch does exactly what Oracle does besides one thing: my code does
not contain a real capitalization function. It sucks when we have
composite names like the portuguese above. I'll post an updated version
later.

SQL> SELECT TO_CHAR(SYSDATE, 'DY dy DAY Day day MONTH Month MON Mon
mon', 'NLS_DATE_LANGUAGE = czech') FROM dual;

TO_CHAR(SYSDATE,'DYDYDAYDAYDAYMONTHMONTHMONMONMON','NLS_DAT
-----------------------------------------------------------

UT ut UTERY   Utery   utery   UNOR     Unor     UNO Uno uno

SQL> SELECT TO_CHAR(SYSDATE, 'DY dy DAY Day day MONTH Month MON Mon
mon', 'NLS_DATE_LANGUAGE = dutch') FROM dual;

TO_CHAR(SYSDATE,'DYDYDAYDAYDAYMONTHMONTHMONMONMON','NLS_DATE_LANGUA

-------------------------------------------------------------------

DI di DINSDAG   Dinsdag   dinsdag   FEBRUARI  Februari  FEB Feb feb

SQL> SELECT TO_CHAR(SYSDATE, 'DY dy DAY Day day MONTH Month MON Mon
mon', 'NLS_DATE_LANGUAGE = portuguese') FROM dual;

TO_CHAR(SYSDATE,'DYDYDAYDAYDAYMONTHMONTHMONMONMON','NLS_DATE_LANGUAGE=PORTUGUESE'

---------------------------------------------------------------------------------

TER ter TERCA-FEIRA   Terca-Feira   terca-feira   FEVEREIRO Fevereiro
FEV Fev fev


--
   Euler Taveira de Oliveira
   http://www.timbira.com/