Nls_date_format Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Nls_date_format

  1. #1
    Join Date
    Oct 2003


    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????

  2. #2
    Join Date
    Nov 2001
    Planet Earth
    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

Click Here to Expand Forum to Full Width