Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: oracle date

Re: oracle date

From: <tedchyn_at_yahoo.com>
Date: Fri, 06 Aug 1999 14:40:29 GMT
Message-ID: <7oes4r$8oo$1@nnrp1.deja.com>


In article <7oe6ff$l96$1_at_zonnetje.nl.uu.net>,   "Frank Leenders" <ftleenders_at_hotmail.com> wrote:
> Hello all,
> in some initialisation file it is possible to set the default
presentation
> of the date datatype for an Oracle instance, most of the times set to
> dd-mmm-yy. In regard of the Y2K problem I asked our DBA's to set that
> default to dd-mm-yyyy. But they say Oracle recommends NOT to do
that!?!? Is
> that true and if so, why?
> Remark: I am writing about instance level of that setting, not about
the
> session setting.
> Thanks
> Frank
>
>

frank, I have not heard this before. for y2k rr and yyyy is the preferred parameter. there is an article in jan/feb oracle magazine tells you the y2k set up and problems and you can get it on line. ted chyn

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 06 1999 - 09:40:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US