Re: Oracle Date Format YYYY

From: <jffaure_at_hotmail.com>
Date: Thu, 27 Jan 2000 21:16:07 GMT
Message-ID: <86qcih$rlp$1@nnrp1.deja.com>

Hello,

You can use NLS_DATE_FORMAT (environnment variable) to set the correct format
example : DD/MM/YYYY

Cordialement,

Jean-Francois

---

Jean-Francois FAURE
Email:hotmail.com
TOULOUSE

WWW :
http://paid2surf.ifrance.com/paid2surf/

http://perso.libertysurf.fr/jffaure/sommaire.html

________________________________________________________________________

In article <86q8g4$oco$1_at_nnrp1.deja.com>,   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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 27 2000 - 15:16:07 CST