Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Date comparison question.

Re: Date comparison question.

From: <saropani_at_my-dejanews.com>
Date: Tue, 26 May 1998 02:42:22 GMT
Message-ID: <6kda6f$sqc$1@nnrp1.dejanews.com>


In article <6k5rah$87a$1_at_nnrp1.dejanews.com>,   andreas.prusch_at_sintec.de wrote:
>
> select * from nls_session_parameters
>
> mfg
> Andreas Prusch
>
> In article <35660005.19812909_at_news1.occa.home.net>,
> JRS
> tern_at_primalsys.com (JRStern) wrote:
> >
> > On Fri, 22 May 1998 21:22:33 GMT, rprendin_at_magi.com (Robert Prendin)
> > wrote:
> > >>Newbie question: how do you get Oracle to display the current setting
> > >>of the nls_date_format? alter session set changes it, but I want to
> > >>see what the default was (I think I know, but, ...). On NT, fwiw.
> > >
> > >select * from v$parameter where upper(name) like '%DATE%';
> >
> > Well, of course! <g> But when I try it, it tells me that default is
> > true, but doesn't tell me what the default is! And, says the same
> > thing, even after I change it with alter session.
> >
> > Joshua Stern
> > JRStern_at_primalsys.com
> >
> >
>

'select value from v$nls_parameters where parameter = 'NLS_DATE_FORMAT';'

will give you the default date format the current session is using.

Hope this works.

Saravanan
saro_at_psoux141.sgp.hp.com

> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon May 25 1998 - 21:42:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US