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

Thread: Changing Default Date Format

  1. #1
    Join Date
    Feb 2001
    Posts
    1
    How do I change the Default Date Format to yyyy-mm-dd (NLS_DATE_FORMAT?).

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    See the alter session command at session level and NLS_DATE_FORMAT init paramter t database level
    Reddy,Sam

  3. #3
    Join Date
    Feb 2001
    Posts
    125

    CHANGING DEFAULT DATE FORMAT

    IT CAN ALL BE DONE BY CHANGING REGISTRY EDITOR
    IF USING WINDOWS CLIENT

    /HKEY__LOCAL_MACHINE/SOFTWARE/ORACLE
    ADD STRING VALUE
    NLS_DATE_FORMATE DD-MM-YYYY


    THANKS
    PITAMBER SONI

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