Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: setting NLS_DATE_FORMAT globally rather than per session?

Re: setting NLS_DATE_FORMAT globally rather than per session?

From: Martin T. <bilbothebagginsbab5_at_freenet.de>
Date: Fri, 22 Jun 2007 04:24:50 -0700
Message-ID: <1182511490.692043.61380@o61g2000hsh.googlegroups.com>


On Jun 21, 9:03 pm, Mark Harrison <m..._at_pixar.com> wrote:
> I've received a request for NLS_DATE_FORMAT to be set globally in a
> database to "Mon dd yyyy hh:mi:ssAM" so that ad hoc queries that
> use the time don't have to use the to_date function.
>
> Is this a reasonable or common thing to do? We're in a single
> timezone in a single country, so there are no localization
> issues to worry about.
>
> TIA!
> Mark
>
> --
> Mark Harrison
> Pixar Animation Studios

What clients are used to run the ad-hoc queries? Maybe you can find a way so that all the clients have some default date format. (e.g. login.sql with sqlPlus)

br,
Martin Received on Fri Jun 22 2007 - 06:24:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US