Xref: alice comp.databases.oracle.server:52195 Path: alice!news-feed.fnsi.net!netnews.com!isdnet!wanadoo.fr!not-for-mail From: "Emmanuel Guyot" Newsgroups: comp.databases.oracle.server Subject: Re: NLS_DATE_FORMAT and RR : Doesn't work ! Date: Sun, 6 Jun 1999 13:25:30 +0200 Organization: Wanadoo, l'internet avec France Telecom Lines: 32 Message-ID: <7jdlr5$n37$1@wanadoo.fr> References: <7jav3p$qnf$1@wanadoo.fr> <928591380.23212.0.pluto.d4ee154e@news.demon.nl> Reply-To: "Emmanuel Guyot" Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Trace: wanadoo.fr 928668325 23655 164.138.213.47 (6 Jun 1999 11:25:25 GMT) X-Complaints-To: abuse@wanadoo.fr NNTP-Posting-Date: 6 Jun 1999 11:25:25 GMT X-Newsreader: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Sybrand Bakker a écrit dans le message <928591380.23212.0.pluto.d4ee154e@news.demon.nl>... >Hi Emmanuel, >You probably ran this statement from a client. Clients should have their own >nls_language and nls_date_format settings, either by setting environment >variables (Unix) or registry values (Windows). If these settings do not >exist, the defaults will be used. In your to_date clause you are not using >the nls_date_format from the server, you are using the (default) >nls_date_format from the client. As this is dd-mon-yy, the date returned is >01-dec-1901. Don't ask me why they have implemented it in this way, I don't >know. You should be able to find more details on technet.oracle.com or >metalink. That's right. I've set the NLS_DATE_FORMAT on the client side and it works fine. Thank you for your help. E.G. ----------------------------------------------------------------------- --------------------->>>> Emmanuel Guyot <<<<-------------------------- 8 Rue des Montées | Phone : [33] (0)2 38 56 42 72 45100 Orléans | Email : emmguyot@altavista.net France | ICQ : 6945538 ----------------------------------------------------------------------- Home Page : http://perso.wanadoo.fr/emmanuel.guyot/belote -----------------------------------------------------------------------