Home » SQL & PL/SQL » SQL & PL/SQL » NLS_TIMESTAMP_FORMAT behavior
NLS_TIMESTAMP_FORMAT behavior [message #279110] Wed, 07 November 2007 00:29 Go to next message
scottwmackey
Messages: 505
Registered: March 2005
Senior Member
Does anybody know what is going on here? If I log in from my machine, I get.
C:\>sqlplus prod/xxxxxx@sl.world 
  
SQL*Plus: Release 10.1.0.2.0 - Production on Tue Nov 6 21:14:15 2007 
  
Copyright (c) 1982, 2004, Oracle.  All rights reserved. 
  
  
Connected to: 
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production 
With the Partitioning, OLAP and Data Mining options 
  
SQL> select value from v$nls_parameters WHERE parameter = 'NLS_TIMESTAMP_FORMAT'; 
  
 VALUE 
 ---------------------------------------------------------------- 
 DD-MON-RR HH.MI.SSXFF AM 
  
When my colleague logs in from a telnet session he gets
[llak@vail ~/scripts]$ sqlplus prod/xxxxxx@sl.world 
   
SQL*Plus: Release 10.2.0.2.0 - Production on Tue Nov 6 21:16:07 2007 
   
Copyright (c) 1982, 2005, Oracle.  All Rights Reserved. 
   
 
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options 
   
SQL> select value from v$nls_parameters WHERE parameter = 'NLS_TIMESTAMP_FORMAT'; 
   
VALUE
----------------------------------------------------------------
YYYY-MM-DD HH24:MI:SS 
   
How is this possible?
Re: NLS_TIMESTAMP_FORMAT behavior [message #279118 is a reply to message #279110] Wed, 07 November 2007 01:02 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He does not have the same local (client) parameters as well as he does not have the same client version.
Each and every one can use his parameter values.

Regards
Michel
Previous Topic: using analytic function to solve my query
Next Topic: ORDER BY DECODE
Goto Forum:
  


Current Time: Fri Dec 09 07:49:26 CST 2016

Total time taken to generate the page: 0.13880 seconds