Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to change nls_session_parameters?
Try, if it's just for a session :
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD';
Andrew Weinstein <andreww_at_anet-dfw.com> a écrit dans le message :
923413233.665.38_at_news.remarQ.com...
> This is for Oracle 8.0.4 running on NT:
>
>
> I need to change the default date from "DD-MON-YY" to "YYYY-MM-DD". When
I
> try the following update query:
>
> UPDATE NLS_SESSION_PARAMETERS SET VALUE = 'YYYY-MM-DD' WHERE PARAMETER =
> 'NLS_DATE_FORMAT'
>
> I receive the following exception:
>
> ERROR at line 1:
> ORA-02030: can only select from fixed tables/views
>
> I looked through the documentation and it goes through this long involved
> process with the NLS Configuration utility.
> "The NLS Configuration Utility is invoked from the command line with the
> following syntax:
> LXBCNF [ORANLS=pathname] [userbootdir=pathname]
> [DESTDIR=pathname] [HELP=[yes |no]]"
>
> When I do a dir on lxbcnf*.* I don't even get a hit on this file.
>
> Can anyone offer some help on how to change the default date format?
>
> Thanks in advance,
>
> Andrew Weinstein
> Dallas, TX
>
>
Received on Tue Apr 06 1999 - 11:28:47 CDT