Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> setting NLS_DATE_FORMAT globally rather than per session?
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 StudiosReceived on Thu Jun 21 2007 - 14:03:33 CDT