Re: Setting date format in Personal Oracle 7

Hi Ceri

Use TO_CHAR(DATE_FIELD,'DATEMASK')

Select TO_CHAR(SOME_DATE_FIELD,'YYYYMMDD') from A_TABLE

Hope this will help

Patrick Beyltjens

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 Sun Jul 20 1997 - 00:00:00 CDT