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

Thread: Default Date Format

  1. #1
    Join Date
    Sep 2001
    Posts
    163
    I think my database has a date problem.

    Oracle 8.1.7
    Win2000

    In the init.ora file:

    NLS_DATE_FORMAT='MM/DD/YYYY'

    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
    Location
    NJ, USA
    Posts
    1,287
    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
    Location
    Madrid, Spain
    Posts
    7,447
    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