Re: NLS_LANG question

From: Sven Kuehne <kuehne_at_uni-muenster.de>
Date: Thu, 01 Apr 1999 10:03:56 +0200
Message-ID: <3703286C.A26579EB@ifgi.uni-muenster.de>

Hi Gary.

Try "select * from SYS.V_$NLS_PARAMETERS;". There is a row like

NLS_DATE_FORMAT                       DD-MON-YY

in this table.

Sven

Gary M. Gettier wrote:
>
> I'm running Oracle server and clients with version 7.3.4 on NT 4.0 and NT 3.51
> machines.
>
> During installation on the clients, a registry variable called NLS_LANG is
> created with a value of AMERICAN_AMERICA.WE8ISO8859P1
>
> No where can I find what the default date format is. I'm assuming it is
> DD-MON-YY, but I would like to know for sure. Is there any place this
> information is stored? A data base table? A file somewhere?
>
> Gary
>
> --
> ----------------------------------------------------------------------------
> Gary M. Gettier openmind_at_erols.com
> "We can change the world that we're living in. Live and let live true
> freedom. Let the reign begin." - Jon Schaeffer (Iced Earth)
Received on Thu Apr 01 1999 - 02:03:56 CST