Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    13

    Unanswered: days between two dates

    Hi all

    I want to find the number of days between two dates.
    When i used datediff function i got an error like
    "invalid column".
    How to overcome the above error??
    Is there any other function to find the days between two dates??

    Sai koushal

  2. #2
    Join Date
    Sep 2003
    Location
    London
    Posts
    56
    Code:
    SELECT
        TO_DAYS( laterDate ) - TO_DAYS( earlierDate ) as days_difference
    FROM
        someTable
    Matt.

  3. #3
    Join Date
    Nov 2003
    Posts
    13
    Hi Matt

    Now i am getting error
    to_days as "invalid column)......
    does the above function depend on oracle version..
    i am using 8.1.7.3.0 version of oracle

    Sai koushal

  4. #4
    Join Date
    Oct 2003
    Posts
    63
    Originally posted by saikoushal
    Hi Matt

    Now i am getting error
    to_days as "invalid column)......
    does the above function depend on oracle version..
    i am using 8.1.7.3.0 version of oracle

    Sai koushal
    Hi!

    Hey, would you like to get an answer for Oracle question in MySQL forum ?

Posting Permissions

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