Re: Date format error

Fabrice BARAFFE wrote:
>
> 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.

I think if you posted the complete query, along with the values of all the NLS parameters of the two boxes, someone could spot the problem in a hurry.

My guess is that the problem is either a subtle conversion problem (which is masked by not having the exact query) or a misset NLS parameter (and I don't know which one because I don't have my manual or my technet password at hand). I don't think the NT regional parameter is relevant here.

-- 
Phil Singer                |    psinger1_at_chartermi.net
Oracle DBA