Calculate Percent Complete

[szeiss]

I'm trying to calculate percentage complete between 2 dates in oracle. Shown below is how I did it in excel.

A3           B3         C3               Pct
4/13/2010   6/3/2011   7/23/2010        24%

=DATEDIF(A3,C3,"D")/DATEDIF(A3,B3,"D")

Thanks,
Sherry

 

[carp]

Assuming that you have a3, b3, and c3 as columns with datatype DATE in a table called my_table,

SELECT (b3-a3)/(c3-a3)*100 FROM my_table;