Re: setting NLS_DATE_FORMAT globally rather than per session?

From: <sybrandb_at_hccnet.nl>
Date: Fri, 22 Jun 2007 00:04:23 +0200
Message-ID: <ectl73trngv2e3922tsfsbvu98u773p2t6@4ax.com>

On Thu, 21 Jun 2007 19:03:33 GMT, Mark Harrison <mh_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

It is a thing that won't work, as NLS setting are always overridden by the client. If the client didn't set them they are overridden to the defaults of the particular Oracle port.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Jun 21 2007 - 17:04:23 CDT