How to change default DATE format

From: Francis Lo <flo_at_Hawaii.Edu>
Date: 28 May 1998 01:39:23 GMT
Message-ID: <6kif8b$chj@news.Hawaii.Edu>

How do I change my Oracle default Date format to something like: DD-MON-YYYY HH24:MI:SS I try add the entry in my INITORCL.ORA file:

NLS_DATE_FORMAT = DD_MON_YYYY_HH24_MI_SS And restart the Oracle instance, still not able to change it. It seems to ingore it.

Appreciated if anyone can help me solve this problem. Thanks!

            /\ - /\                                       /\ - /\
 /\       /  O   O  \           Francis T. Lo           /  O   O  \       /\
 \ / / /  |  /o o\  |        Programmer/Analyst         |  /o o\  |  \ \ \ /
   \      \  \   /  /  MAXIM Integrated Products, Inc.  \  \   /  /      /
    \ \ \ \ \ \ \ /                                       \ / / / / / / /
     |||     || ||        flo_at_uhunix.its.hawaii.edu        || ||     |||
     ---     -- --                                         -- --     ---

Received on Wed May 27 1998 - 20:39:23 CDT