RE: Anyone explain this to me

  • From: "David Sharples" <dsharples@xxxxxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Sep 2004 15:32:36 +0100

Thanks, was a combination of nls_language and nls_territory

Dave

-----Original Message-----
From: Ganesh Raja [mailto:ganesh.raja@xxxxxxxxx]=20
Sent: 29 September 2004 15:25
To: David Sharples
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Anyone explain this to me

NLS_LANG Setting ...

~
Ganesh


On Wed, 29 Sep 2004 15:10:45 +0100, David Sharples
<dsharples@xxxxxxxxxxxxxxxxxxxxx> wrote:
> From Unix machine
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
> With the Partitioning option
> JServer Release 9.2.0.4.0 - Production
>=20
> SQL>
> SQL>
> SQL> select to_char(sysdate, 'D') from dual;
>=20
> TO_CHAR(SYSDATE,'D')
>
------------------------------------------------------------------------
> ---
> 4
>=20
> On a windows machine connecting to the same database
>=20
> SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 29 14:59:13 2004
>=20
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
>=20
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
> With the Partitioning option
> JServer Release 9.2.0.4.0 - Production
>=20
> SQL> select to_char(sysdate, 'D') from dual;
>=20
> TO_CHAR(SYSDATE,'D')
>
------------------------------------------------------------------------
> ---
> 3
>=20
> ?????
>=20
> Thanks
>=20
> Dave
>=20
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: