Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    UK
    Posts
    21

    Unanswered: Calculating Dates

    I have to calcutale dates, and I have no Idea of which operation to use.

    I have a start date and a expire date and I have to give the time remaining
    to expire.
    it would be actual date - expire date. Is there any way to do that in
    Oracle /pl/sql?

    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    It would be (expire_date - actual_date), which will give you a result in days. If the dates include a time component, the answer may be fractional, e.g. 4.765 days.

  3. #3
    Join Date
    Jan 2004
    Location
    UK
    Posts
    21
    you are right. I found it. is (self.expire_date-sysdate)
    subtractin my expire_date row by the sysdate.

    Thanks

Posting Permissions

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