Re: Date format help

From: Douglas Dunnigan <douglas_at_yogananda-srf.org>
Date: 1997/06/13
Message-ID: <01bc7825$01d09060$b3570c26@systems-douglas>#1/1

Jane Mikityanskaya <jane_at_hnrc.tufts.edu> wrote in article <339F144C.EC934043_at_hnrc.tufts.edu>...
> I can't get any luck in setting up a non-default date format.
> After submitting a statement
>
> SQL> alter session set nls_date_format = 'MM-DD-YYYY';
>
> NLS_DATE_FORMAT parameter has changed to a new format.
> BUT browsing the actual data with the SELECT statement truncates it up
> to 9 characters.
> Can someone told where I am wrong?

Try setting NLS_DATE_FORMAT = MM-DD-YYYY in the registry (or in ORACLE.INI if you're using a 16-bit app).

Doug Received on Fri Jun 13 1997 - 00:00:00 CDT