In article <8q6r81$d5g$1_at_nnrp1.deja.com>,
rezaferry_at_my-deja.com wrote:
> In article <39C5F6BF.689370EC_at_NOSPAMramboll-it.dk>,
> mhr_at_NOSPAMramboll-it.dk wrote:
>
> > One way is to change the default date format in order to produce the
> > formatting of dates that you want. This could be done within your
session
> > and thereby avoiding influencing other users/applications conencted
to the
> > database. In SQL*PLUS the default date format is change with for
example:
> >
> > (c:\tmp) SQL> alter session set nls_date_format = 'dd-mm-yyyy
hh24:mi:ss';
> >
> > Session altered.
> Thanks for the answer.
>
> A follow up question.
>
> What if I want it to influence all other users/applications connected
> to the database what do I alter?
>
See the Referece manual section on init.ora parameters for the
nls_date_format. But beware changing the parameter at the database
level will require all code that uses/expects the normal default format
of 'dd-mon-yy' to be changed. This is usually not practical.
--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Sep 19 2000 - 07:54:35 CDT
