DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Nls_date_format

  1. #1
    Join Date
    Oct 2003
    Posts
    312

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

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