LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (July 2004, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 19 Jul 2004 15:32:13 -0400
Reply-To:   Jim Groeneveld <jim.groeneveld@VITATRON.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Jim Groeneveld <jim.groeneveld@VITATRON.COM>
Subject:   Re: Trying to compare todays date to the contents of a date field in an oracle database.
Comments:   To: david Fickbohm <DavidF@HOMEGAIN.COM>

Hi Dave,

Wouldn't it be better, for reasons of security, to make your username and password unrecognizable? I did that in the quoted part below.

Regards - Jim.

On Mon, 19 Jul 2004 12:07:47 -0700, David Fickbohm <DavidF@HOMEGAIN.COM> wrote:

>People, >I am working in SAS v8.1, in a windows environment. Oracle 8i. > >I am trying to determine whether the contents of a field called >d_membership_expire_ts (Timestamp) is less than the current date. Currently >I get a message saying I have an invaled relational operator. > >Any and All help will be greately appreciated. > >Thanks >Dave > > >PROC SQL; >connect to oracle(user='******' pass='******' path='reporting2'); [.........] >Dave Fickbohm >Data Mining Analyst >Homegain+ >2450 45th St. >Emeryville, CA, 94608 >Phone 510 655 0800 ext 4151


Back to: Top of message | Previous page | Main SAS-L page