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: C. Mason <cmason_at_aai.arco.com>
Date: Tue, 26 May 1998 17:21:56 GMT
Message-ID: <EtKqut.GrH@news.arco.com>


Try the following: select * from v$parameter where name='nls_date_format'; JRStern wrote in message <35660005.19812909_at_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 Tue May 26 1998 - 12:21:56 CDT

Original text of this message

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