Re: Date format

Bo Seiffert wrote:
>
> 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.

Its probably set on your client as well - eg for PC, ensures that the registry setting is correct as well.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse