Re: Oracle Date Format YYYY

From: Daniel <delj_at_flash.net>
Date: 27 Jan 2000 16:17:38 EST
Message-ID: <86qcli$ob0@journal.concentric.net>

Check out NLS_DATE_FORMAT in the init settings documentation.

Daniel
Austin, TX

<bigbend1_at_my-deja.com> wrote in message news:86q8g4$oco$1_at_nnrp1.deja.com...
> Greetings,
>
> In Oracle8 is there a way of changing the screen
> display date format from DD-MMM-YY to DD-MMM-YYYY
> so that YYYY is always displayed?
>
> For example, reformat 01-Dec-99 to 01-Dec-1899?
>
> Are there any potential problems with this with
> reports, the SQL*Loader, etc?
>
> thanks
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jan 27 2000 - 15:17:38 CST