Date format on Oracle iAS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Date format on Oracle iAS

  1. #1
    Join Date
    Jan 2003
    Location
    Thailand
    Posts
    29

    Date format on Oracle iAS

    Problem processes:
    1. Query by logging in directly to the host:
    SQL> select * from nls_session_parameters where parameter = 'NLS_DATE_FORMAT';

    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_DATE_FORMAT DD-MON-RR

    ************************************************


    2. Set the NLS_DATE_FORMAT in init.ora:
    NLS_DATE_FORMAT=DD/MM/YY

    ************************************************


    3. Shutdown and Startup DB (Oracle 8.1.7).


    4. Query by logging in directly to the host (again):
    SQL> select * from nls_session_parameters where parameter = 'NLS_DATE_FORMAT';

    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_DATE_FORMAT DD/MM/YY

    ************************************************


    5. Run PL/SQL code that containing the SQL statement as the 1st and 4th via a web browser (served by Oracle iAS):

    -----------------
    NLS Session is
    -----------------
    Parameters Values
    ------------------------ ------------------
    NLS_DATE_FORMAT DD MON RRRR

    ************************************************

    Questions:
    1. Why is NLS_DATE_FORMAT = 'DD MON RRRR'?
    It should be NLS_DATE_FORMAT = 'DD/MM/YY' or not?

    2. If Oracle iAS can specify the NLS session parameter, how can I do?
    (I would not like to specify its from my code as using DBMS_SESSION.SET_NLS or other)

    PS. I know where I can set NLS parameter at SESSION and SYSTEM level but I'm confused why NLS_DATE_FORMAT='DD MON RRRR' was returned by Oracle iAS that I never set the specific NLS paramter on the server. --by default NLS_DATE_FORMAT is 'DD-MON-RR' right?
    Regards,
    P.Peach

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    The problem is not exactly the same, but the solution might help.

    http://www.dbasupport.com/forums/sho...highlight=9iAS

    Good luck.
    David Knight
    OCP DBA 8i, 9i, 10g

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