Re: Setting date format in Personal Oracle 7

the only way to change the date format is with to_char(<date>, FMT) this will not change the way Oracle Stores the date only the way oracle presents the date.

On Sun, 13 Jul 1997 16:10:48 GMT, ceri_at_n-ary.com (Ceri Moran) wrote:

>
>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
Received on Wed Jul 16 1997 - 00:00:00 CDT