Re: Anyone know how overwrite or change the date format by default?

On Wed, 09 Aug 2006 09:46:55 -0700, lala4life wrote:

> i'm in win32 with Oracle 10g.
> Thank in advance

For the system, or for only one session?

For the system,
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams122.htm#sthref516

For the session (eg: only for specific users), http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2012.htm#i2231814 and search for NLS_DATE_FORMAT. Since you want this as a default, if only for specific users consider login triggers

(Amazing what can be found in the documentation!)

--
Hans Forbrich (mailto: Fuzzy.GreyBeard_at_gmail.com) *** Feel free to correct me when I'm wrong! *** Top posting [replies] guarantees I won't respond. Received on Wed Aug 09 2006 - 12:09:09 CDT