Re: changing & questions on NLS_DATE_FORMAT on nt

What you are talking about is the external presentation of an oracle date field. Internally, the date is stored in the same format no matter what you set the nls setting to.

You should use TO_CHAR(date,'format') whenever selecting a date.

Andrew.

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
Received on Wed May 05 1999 - 23:03:03 CDT