Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Bangalore
    Posts
    44

    Question Unanswered: Settign date format to DD-MM-YYYY

    Hi Friends,

    I want to set my sysdate as DD-MM-YYYY in oracle8i.
    I did using alter session set NLS_DATE_FORMAT='DD-MM-YYYY';
    This is session dependent.
    I want to set it for the database instance.Let me know where should i set this option in oracle 8i.
    I tries setting in init.ora file, but it is not taking.


    Thank you
    Mahesh Kumar BK
    Last edited by mahesh_bk1; 01-30-03 at 06:44.

  2. #2
    Join Date
    Jan 2003
    Location
    й
    Posts
    18
    I think you maybe use spfile

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •