Re: Oracle Date Format YYYY

From: Leonid Moiseichuk <ldm_at_sprl.sps.mot.com>
Date: Fri, 28 Jan 2000 11:20:40 +0300
Message-ID: <38915158.4C7200DA@sprl.sps.mot.com>

Try alter session or setting environment variable for NLS_DATE_FORMAT /ldm

bigbend1_at_my-deja.com wrote:

> 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 Fri Jan 28 2000 - 02:20:40 CST