Originally posted by DaPi
So why didn't PSoni get this error? (Which is why I said "somehow".)
Code:
SCS_DBA@U144> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.1 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
SCS_DBA@U144> select * from NLS_SESSION_PARAMETERS where PARAMETER='NLS_DATE_FORMAT';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_DATE_FORMAT DD-MON-YY
SCS_DBA@U144> select to_date(sysdate,'DD-MM-RRRR') from dual;
TO_DATE(S
---------
06-JUL-03
Last edited by abhaysk; 07-06-2003 at 09:50 AM.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Reply With Quote