Re: NLS_DATE_FORMAT and RR : Doesn't work !

From: Emmanuel Guyot <Emmanuel.Guyot._at_wanadoo.fr>
Date: Sun, 6 Jun 1999 13:25:30 +0200
Message-ID: <7jdlr5$n37$1@wanadoo.fr>

Sybrand Bakker a écrit dans le message
<928591380.23212.0.pluto.d4ee154e_at_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_at_altavista.net
France                         | ICQ       : 6945538
-----------------------------------------------------------------------

Home Page : http://perso.wanadoo.fr/emmanuel.guyot/belote

Received on Sun Jun 06 1999 - 06:25:30 CDT