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 SQL> SQL> SQL> select to_char(sysdate, 'D') from dual; TO_CHAR(SYSDATE,'D') ------------------------------------------------------------------------ --- 4 On a windows machine connecting to the same database SQL*Plus: Release 9.2.0.1.0 - Production on Wed Sep 29 14:59:13 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 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 SQL> select to_char(sysdate, 'D') from dual; TO_CHAR(SYSDATE,'D') ------------------------------------------------------------------------ --- 3 ????? Thanks Dave -- //www.freelists.org/webpage/oracle-l