Home » SQL & PL/SQL » SQL & PL/SQL » NLS_DATE_FORMAT from 10g client to 8i database
NLS_DATE_FORMAT from 10g client to 8i database [message #184466] Wed, 26 July 2006 12:12 Go to next message
bztom33
Messages: 95
Registered: June 2005
Member
Hi,

I am having problem to get Oracle 10g version 10.2.0.1.0 client to recgonize the correct date format from Oracle 8i database verison 8.1.7.

I already set the NLS_DATE_FORMAT on init.ora on Oracle 8i to nls_date_format='MM/DD/YYYY HH24:MI' and it's working properly for Oracle 8i and earlier clients.

My problem is when I am trying to connect to Oracle 8i database from a Oracle 10g client. The date format is default to DD-MON-YY format which it's not the correct format.

Is there a parameter setting on Oracle 10g client that I can set so that it will always using 'MM/DD/YYYY HH24:MI' format for date ?

Thanks,


Tom


Re: NLS_DATE_FORMAT from 10g client to 8i database [message #184473 is a reply to message #184466] Wed, 26 July 2006 13:25 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be your local 10g client settings are overriding the server settings. Did you also check you environment/glogin.sql/login.sql etc? may be something is explicitly set.
Morever , 10R2 client against 8.1.7 server is currently under EMS (extended support). I would not be surpised, if you come across many more issues.

Re: NLS_DATE_FORMAT from 10g client to 8i database [message #184935 is a reply to message #184473] Fri, 28 July 2006 15:28 Go to previous message
bztom33
Messages: 95
Registered: June 2005
Member
I decided to use a global trigger to alter the user's session to use the correct NLS_DATE_FORMAT.

[Updated on: Fri, 28 July 2006 15:28]

Report message to a moderator

Previous Topic: read only column in table
Next Topic: DBMS_PROFILER - Total_Time - format?
Goto Forum:
  


Current Time: Fri Dec 02 14:29:36 CST 2016

Total time taken to generate the page: 0.09790 seconds