Date:         Mon, 20 Jun 2011 13:24:04 -0700
Reply-To:     mlhoward@avalon.net
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mary <mlhoward@AVALON.NET>
Subject:      Re: SQL pass through Oracle date?
Comments: To: Ya Huang <ya.huang@AMYLIN.COM>
Content-Type: text/plain; charset="UTF-8"

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