Home » RDBMS Server » Server Administration » nls_date_format problem
nls_date_format problem [message #198915] Thu, 19 October 2006 02:47
suvv
Messages: 17
Registered: October 2006
Junior Member
I connected to a 9.2.0.5 database using sqlplus 8.1.7 and run the following...

alter session set nls_date_format = 'MM-DD-YYYY HH24:MI:SS'
/
select sysdate from dual
/

SYSDATE
---------
16-OCT-06

Note the date format is incorrect. I can connect to the same database with sqlplus 9.2.x or sqplus 10.2.x and run the same command and the date format is correct. Example is below.

alter session set nls_date_format = 'MM-DD-YYYY HH24:MI:SS'
/
select sysdate from dual
/


SYSDATE
-------------------
10-16-2006 23:37:15

My OS is SunOS-32 bit .
Plese help me to solve out this issue.
Previous Topic: Database is too slow
Next Topic: Change Hostname for databse server
Goto Forum:
  


Current Time: Wed Dec 07 09:06:16 CST 2016

Total time taken to generate the page: 0.11930 seconds