Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: setting NLS_DATE_FORMAT globally rather than per session?
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