Re: Date in GMT for some sessions only

  • From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 9 Jun 2004 05:36:56 -0700 (PDT)

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@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: