-
Nls_date_format
Right now, NLS_DATE_FORMAT is currently set to DD-MON-RR. And I want to change it to MON-DD-RR so I add the NLS_DATE_FORMAT = "MON-DD-RR" and when I query SYSDATE from dual nothing is changed??? or even query the NLS_DATABASE_PARAMETERS and the NLS_DATABASE_PARAMETERS still default to DD-MON-RR
Any advises????
-
where did you change NLS_DATE_FORMAT? did you restart your DB? (for 8i and below)
another way to get such date format is
SQL> select to_char(sysdate,'MON-DD-RR') from dual;
__________________________________________
Why on earth OCP is to be proud
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|