Re: changing & questions on NLS_DATE_FORMAT on nt

hello,

This shouldwork:

NLS_DATE_FORMAT = "MM-DD-YYYY" Remember changes in the parameterfile only take effect after the shutdown & startup of the database! Incorrect changes are ignored, sometimes the faulty changes are displayed during startup. (Do you have the right parameterfile?)

You could try in SQLPlus...

alter session set NLS_DATE_FORMAT = "MM-DD-YYYY";

select sysdate from dual;

...to see if you got the syntax right.

if you're using developer, you can use the format-property of the item to display (& enforce) the date however you want.

luck,
theo

> shawn wrote:
> >
> > Hi..maybe someone can help me...
> >
> > On oracle 7.3.2.2.1 on nt the default value of sysdate is MM-DD-YY (I
> > believe can't remember at moment) it seems I've tried figuring out how
> > to change it at the instance level (making it the default) but doesn't
> > seem to work for me =(
> >
> > in initorcl.ora I added
> > NLS_DATE_FORMAT = "MM-DD-YYYY"
> >
> > It didn't have any effect...
> >
> > other question would be if it's possible to include the time by
> > default also? then if it can include time will the subtraction, add,
> > etc of the date field still work correctly?
> >
> > Any help would be appreciated...thanks,
> > shawn
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu May 06 1999 - 05:06:08 CDT