Re: calculating ratio of two datetime columns

2004-08-25 Thread SGreen
MySQL has several functions for dealing with date and time values, many of which exist only as of 4.1.x. Which ones are available to you depend on your version. Please read: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html Actually, I believe that the formula you wrote is almost t

calculating ratio of two datetime columns

2004-08-24 Thread 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_Sch