Re: Date comparison question.

From: JRStern <JRStern_at_primalsys.com>
Date: Fri, 22 May 1998 22:46:40 GMT
Message-ID: <35660005.19812909@news1.occa.home.net>

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 Received on Fri May 22 1998 - 17:46:40 CDT