DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2001
    I think my database has a date problem.

    Oracle 8.1.7

    In the init.ora file:


    From v$parameter: MM/DD/YYYY

    Problem. When I "Select sysdate from dual" I get 27-FEB-02.
    When I select from a table that has a date value I get: 27-FEB-02.

    Why can I not get the date in MM/DD/YYYY format?

  2. #2
    Join Date
    Sep 2001
    NJ, USA
    Oracle has 2 place where it use date format.
    server site setup using NLS_DATE_FORMAT in init$SID.ora
    client site setup in:
    for unix - in .profile(.login)
    for Win - in register (Local Mashle---> Oracle)

    sqlplus always use client site setup for NLS_DATE_FORMAT.
    U haven't any errors and problem with date format.

  3. #3
    Join Date
    Jun 2000
    Madrid, Spain
    well there are three places really,

    1. client enviroment (nls_lang if nls_date_format is not used)
    2. initSID.ora
    3. Database settings

    if 1 is not set it uses 2 if 2 is not set it uses 3

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.