Date:         Mon, 20 Jun 2011 13:31:06 -0700
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: SQL pass through Oracle date?
Comments: To: mlhoward@avalon.net
In-Reply-To:  <20110620132404.A11594EF@resin09.mta.everyone.net>
Content-Type: text/plain; charset=us-ascii

Do you think that and less than condition and a more than condition are better than a single between condition?  If one construct is faster than the other, Oracle's not optimizing very well.  But for all I know, they're not.


On Jun 20, 2011, at 1:24 PM, Mary wrote:

> Oracle SQL is:
>
> where cdt <= to_date('06102011','MMDDYYYY') and
> cdt >= to_date('06162011','MMDDYYYY');
>
>
> --- ya.huang@AMYLIN.COM wrote:
>
> From: Ya Huang <ya.huang@AMYLIN.COM>
> To: SAS-L@LISTSERV.UGA.EDU
> Subject:      SQL pass through Oracle date?
> Date:         Thu, 16 Jun 2011 17:08:54 -0400
>
> Hi there,
>
> What would be the syntac for a SQL pass through to Oracle:
>
> The SAS code is
>
> where '10JUN2011'd <= cdt <= '16JUN2011'd
>
> Pass through to Oracel is?
>
> where ???? <= cdt <= ????
>
> Thanks
>
> Ya