Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What problems occur if I change NLS_DATE_FORMAT??????????????

Re: What problems occur if I change NLS_DATE_FORMAT??????????????

From: David Van Zandt <dvanzandt_at_iquest.net>
Date: Sun, 20 Dec 1998 10:43:50 -0500
Message-ID: <367D1B36.D333886C@iquest.net>


One of the OpenWorld sessions brought to my attention the delightful fact that setting the NLS_DATE_FORMAT WITHOUT ALSO SETTING THE NLS_LANGUAGE may provide you with unspecified results.... IOW make sure to specify ENGLISH, or whatever, as the date format changes for different language groups.

Konstantin Kivi wrote:
>
> abalbekov_at_usa.net wrote:
>
> > I changed it from 'MM/DD/YYYY' to 'MM/DD/RRRR' in my database two weeks ago
> > - no complaints so far...
>
Received on Sun Dec 20 1998 - 09:43:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US