Re: Setting date format in Personal Oracle 7

From: miguel <jmiguel_at_cet.pt>
Date: 1997/07/15
Message-ID: <01bc9106$81fcf040$0a0a2c0a@jmiguel.cet.pt>#1/1

Ceri Moran <ceri_at_n-ary.com> wrote in article <33c8fe10.17507985_at_clientnews.wisper.net>...
> Hi
>
> I am trying to change the date format in PO7 and
> I am not having much luck.
>
> The format at present is '10-JUL-97'.
>
> I wish it to be '19970710' or at the very least '10-JUL-1997'.
>
> Can anyone suggest anything?
>
> Thanks
>
> Ceri Moran
>

Temporary (session):
ALTER SESSION SET NLS_DATE_FORMAT=´YYYYMMDD´; Permanent ( init.ora):
nls_date_format="YYYYMMDD"
and then shutdown the database

Miguel
Portugal Received on Tue Jul 15 1997 - 00:00:00 CDT