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
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