Re: How to change default DATE format

From: <saropani_at_my-dejanews.com>
Date: Fri, 29 May 1998 05:37:14 GMT
Message-ID: <6klhib$q6t$1@nnrp1.dejanews.com>

In article <6kif8b$chj_at_news.Hawaii.Edu>, flo_at_Hawaii.Edu (Francis Lo) wrote:
>
> 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 || || |||
> --- -- -- -- -- ---
>

Hi Francis,

It should work if you include a line in initSID.ora file as:

NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' You can check this from svrmgrl by:

show parameter nls_date

You can change your session's default format using:

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' This is what i have been doing when i want to change date format sessionwide or databasewide.

Hope this helps.

Regards,
Saravanan

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 29 1998 - 00:37:14 CDT