Re: Date in GMT for some sessions only

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Wed, 9 Jun 2004 05:36:56 -0700 (PDT)
Message-ID: <20040609123656.89179.qmail@web80512.mail.yahoo.com>

to do it for some sessions you can setup a logon trigger for those session with a call to a stored proc.  

which has an alter session so that that session has the appropriate nls_date_format. VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote: Folks

For some of the Sessions only, need the date in GMT with time down to seconds.

Is there some Value for NLS_DATE_FORMAT parameter for this?

Thanks

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jun 09 2004 - 07:33:45 CDT