| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
