Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Help : Converting Dates to Chars
Hi,
You can set NLS_DATE_FORMAT in the init.ora file to set a default date format for the entire instance. Pls. refer to the Server manuals for details.
I think some client application like Forms allows you to set the parameter for a given client too.
But all in all I think you should be careful when mixing different date formats across one application. Typically this can cause (or reveal!) problems in the date handling of your database and application(s).
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?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 19 2000 - 02:30:38 CDT