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