Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: sql*plus or pl/sql question

    How would you calculate the difference between two dates?

    Apparently i should use DATEDIFF ... how do i use DATEDIFF?

  2. #2
    Join Date
    Jan 2003
    Location
    China
    Posts
    38

    Just use the '-'

    For example, it looks like this:
    select date1 - date2 from ...
    Fan Yi

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    "DATEDIFF" is not an Oracle date function; follow this link to view and read more about date functions available in Oracle 10g rel. 2.

    And yes, 884813's answer will give you desired result.

Posting Permissions

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