Date format error

From: Fabrice BARAFFE <fabrice_at_dune-concept.com>
Date: Thu, 13 Sep 2001 15:52:43 +0200
Message-ID: <HS2o7.31$T3.1142@tengri.easynet.fr>

Hello world,

I meet a problem with date format on Oracle 8i (8.1.6.2). We install the same web application (based on Tomcat + servlet + Oracle) on 2 servers:
1- NT Server 4.0 french version + Oracle 8.1.6.2 french version 2- NT Server 4.0 US version + Oracle 8.1.6.2 US version

On the first server (french version) when we use TO-CHAR() function in a view, to store a date into a string db-field (like this: TO_CHAR(Iat_DataContrat.CtrDateEcheance,'DD/MM/YYYY') CtrDateEchenace) the result is "13/09/2001", as we want.

On the second server (US version) the result of the same query is "13;09;2001" !
/ separator is replaced by ;

Is anybody know the reason ?

PS: in both servers, the NT regional parameter: "date separator" is / caracter.

Thanks for ur help. Received on Thu Sep 13 2001 - 08:52:43 CDT