Re: Date format error

Check the NLS_DATE_FORMAT parameter value in the V$NLS_PARAMETERS view. I would imagine that in your French installation the format mask is 'DD/MM/YYYY', whereas in your U.S. installation the format mask is 'DD;MM;YYYY'.

You might also check the registry entries, as the NLS_ parameters may also be located there.

David Fitzjarrell

"Fabrice BARAFFE" <fabrice_at_dune-concept.com> wrote in message news:<GL2o7.30$T3.1031_at_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 - 13:52:31 CDT