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

Thread: date format

  1. #1
    Join Date
    Mar 2005
    Posts
    143

    date format

    I have a 9i db and set the nls_date_format in the initialization parameters to DD-MON-YYYY. when I select a field in sqlplus that has a date value it shows it in DD-MON-YY. I even set the NLS_lang registry key for oracle to DD-MON-YYYY. Why wont the date format show what I set it for?

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Do a show all from sql plus to see what the client is set for.

  3. #3
    Join Date
    Feb 2003
    Location
    London
    Posts
    170
    Do a

    Code:
    alter session set NLS_DATE_FORMAT = 'DD-MON-YYYY';
    and then run your query or
    why dont you do a select like
    Code:
    select to_char(datefield,'DD-MON-YYYY') from table;
    It doesnt make sense to change the nls_lang for this.
    thomasp

  4. #4
    Join Date
    Apr 2006
    Posts
    1

    Thumbs up

    there may be a problem with your sql editor
    i tried it in sql plus it works fine....but when i am issuing the same in toad it is not working.....


    M Jain

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not working? define not working

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