Re: Date format

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 2000/04/07
Message-ID: <955118646.7673.1.pluto.d4ee154e@news.demon.nl>#1/1

And if he doesn't use sqlplus?

Regards,

Sybrand Bakker, Oracle DBA

"Bo Seiffert" <fox61_at_hotmail.com> wrote in message news:8ckpr4$l0t$1_at_nnrp1.deja.com...
> In you login.sql file put: alter session set nls_date_format='DD-MM-
> YYYY HH24:MI:SS
> In article <38ed868f_1_at_news1.prserv.net>,
> "Mike Ng" <mike_at_email.tech-trans.com> wrote:
> > Hi all,
> >
> > I want to use the date format like this "DD-MM-YYYY HH24:MI:SS" but I
need
> > use the sql
> > "alter session set nls_date_format='DD-MM-YYYY HH24:MI:SS" to setup
the
> > environment every time I login.
> >
> > I have try to add the following format in init.ora file but it did
not work.
> > The string I add is NLS_DATE_FORMAT="DD-MM-YYYY HH24:MI:SS" Is there
> > elsewhere I need to change? Please give me some hints.
> >
> > Thanks a lot.
> >
> > Regards,
> > Mike Ng
> >
> >
>
> --
> Bo Seiffert
> Somewhere in Denmark
> Even if you are on track, you will get run over if you just sit there
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 07 2000 - 00:00:00 CDT