Re: Date comparison question.

From: <andreas.prusch_at_sintec.de>
Date: Sat, 23 May 1998 06:45:36 GMT
Message-ID: <6k5rah$87a$1@nnrp1.dejanews.com>

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
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sat May 23 1998 - 01:45:36 CDT