Re: oracle date

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.

I'm setting it there and it works for me. This is Oracle 7.3.4; maybe you're on an earlier version where it isn't supported? It can be overridden by client environment variables, including not only nls_date_format but also nls_lang. And it can be overridden by ALTER SESSION and TO_CHAR.

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa