| Date: | Mon, 19 Jul 2004 15:18:53 -0700 |
|---|
| Reply-To: | Patrick.F.O'Neill@KP.ORG |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Patrick F O'Neill <Patrick.F.O'Neill@KP.ORG> |
|---|
| Subject: | Re: Trying to compare todays date to the contents of a date field
in an oracle database. |
|---|
|
| Content-Type: | text/plain; charset="US-ASCII" |
|---|
I think you can just compare a timestamp directly to SYSDATE in this SQL
passthrough. The () after SYSDATE() in your original are not part of
Oracle syntax.
PROC SQL;
connect to oracle(user='megan' pass='mzdm2xt' path='reporting2');
create table agents as select *
FROM
USER_OWN.T_AGENT A1,
USER_OWN.T_USER A2,
USER_OWN.T_MEMBERSHIP A3
where
D_MEMBERSHIP_EXPIRE_TS < SYSDATE
AS....
;
quit;
|
