days between two dates

saikoushal · #1 (**permalink**) 11-17-03, 04:56

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

Mincer · #2 (**permalink**) 11-17-03, 05:34

Code:

SELECT
    TO_DAYS( laterDate ) - TO_DAYS( earlierDate ) as days_difference
FROM
    someTable

Matt.

saikoushal · #3 (**permalink**) 11-17-03, 06:06

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

khibinite · #4 (**permalink**) 11-17-03, 06:40

Quote:

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

?

Internet Services

Web Development

Digital Marketing

Consumer Tech