average time standing

[jlindahl]

i am using an oracle db. this is my sql stmt.
select avg((to_date('10/23/2003','MM/DD/YYYY') - lastuserdate))
from tablename

my question is, what is exactly happening? i get a result of 400.509981158606....

what i am doing is taking a date column (lastuserdate) and trying to find the average days between lastuserdate and currentdate for all the records. what i don't understand is what is that 400? days?

 

[karluk]

Yes, it's 400+ days. For example

select avg(to_date('23-OCT-03') - to_date('20-OCT-03')) from dual;

will return 3, because there are three days between the two dates.