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