you need to set this parameter in your initSID.ora parameter file
NLS_DATE_FORMAT = 'YYYY-MM-DD'
Andrew Weinstein wrote:
> 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 Fri Apr 09 1999 - 04:15:40 CDT
