Results 1 to 4 of 4
  1. #1
    Join Date
    May 2009
    Posts
    2

    Unanswered: ODBC import options

    Hi all, first post here so I hope this makes sense. We use a data mining tool here at work to pull data from an application which is running an Oracle 8.x database through an ODBC driver connection. I need to create a series of different tests in our data mining application and want to limit my record selection using a date filter.

    For example, there is a date field in one of the tables called RS_DATE. I need to get the "age" of that date and only import records where the value is 90 days or more in the future from the current date.

    Something like this:
    >>>WHERE RS_DATE > 90 days from TODAY

    I have other similar tests to build, but I'm pretty sure I can figure the rest out if I get the initial syntax.

    Thanks in advance.

    Kevin

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Sysdate+90
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    May 2009
    Posts
    2
    Quote Originally Posted by anacedent
    Sysdate+90
    Hey,

    Thank you very much, that seems to work. Where can I locate a list of similar "commands"? I was looking online and searching through manuals but wasn't sure what to call them. I found something on "to_date" which will be useful for some other tests, but didn't see much else.

    Thanks again!

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Search and Download Oracle Database, Application Server, and Collaboration Suite Documentation
    Select the link for your version of Oracle; but I do not think V8 is still available.
    You want the SQL Reference manual
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •