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: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 22 Jun 2007 02:52:30 GMT
Message-ID: <OPGei.7184$s57.38@newsfe07.phx>


Mark Harrison <mh_at_pixar.com> wrote in news:9Yzei.2715$vi5.1180 @newssvr17.news.prodigy.net:

> 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.

HUH?
> don't have to use the to_date function.

TO_DATE is used to convert strings to date datatype!

Are you sure you even know how to spell S-Q-L? Received on Thu Jun 21 2007 - 21:52:30 CDT

Original text of this message

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