calculating ratio of two datetime columns

[Viswanatha Rao]

I am selecting two columns each of type DateTime from a mysql table from
perl.
 
my $sth = $dbh->prepare("SELECT End_Date_Scheduled, End_Date_Actual FROM
Table1 WHERE ID='10'" );
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
    print"Found: end date scheduled = $ref->{'End_Date_Scheduled'}, end
date actual = $ref->{'End_Date_Actual'}\n";
}
$sth->finish();
 
It works.
 
However, I need to find the % ratio = ((end_date_scheduled -
end_date_actual)/end_date_scheduled) * 100
 
To do this I need the DateTime values in seconds. Can someone help me
with this?
 
 
 
Best Regards
Vishwa Rao