Problem with Date Data Type Translations

From: <jalonso_at_filabres.ualm.es>
Date: 1995/12/14
Message-ID: <4apt3p$j5e_at_erika.cica.es>#1/1


We have the next problem:

 We works with Oracle RDBMS 6.0.34.3.2, Do you remember it?.  Database language is Spanish_spain.we8dec, and user language variable too.  With SQL*Forms 3.0.16.4.3, when we use TO_CHAR or TO_DATE functions don't  work correctly with Spanish language.

 SQL*Forms reads correctly a date variable in spanish but when we use TO_CHAR  to convert it then we get it in english.

 Example:

           fecha is date.
           fecha = '14-dic-95';  ( DECember -> in spanish -> DICiembre )
          MESSAGE(TO_CHAR(fecha,'dd-mon-yy'));
           and result is:
             14-dec-95

Previous Thanks.   Received on Thu Dec 14 1995 - 00:00:00 CET

Original text of this message