Oracle dates query

Results 1 to 2 of 2

Thread: Oracle dates query

  1. #1
    Join Date
    Dec 1969

    Default Oracle dates query

    I have an Oracle table that has (among others) the following fields: <BR>DATE_COMLETED <BR>INTERVAL <BR>EMAIL_ADDRESS <BR><BR>INTERVAL is a number field and refers to a number of days. <BR><BR>I need a query that will give me EMAIL_ADDRESS for every record where the difference(in days) between DATE_COMPLETED and the sysdate is equal to or greater than INTERVAL <BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle dates query

    Check the Oracle docs. I&#039;m sure they have a DATEDIFF or similar function

Posting Permissions

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