Changeset 31888 for trunk/tools/czartool/MySQLDb.pm

Timestamp:

Jul 15, 2011, 4:17:14 PM (15 years ago)

Author:

rhenders

Message:

added method to get time in the middle of two other times

File:

• trunk/tools/czartool/MySQLDb.pm (modified) (1 diff)

trunk/tools/czartool/MySQLDb.pm

@@ -99 +99 @@
 ###########################################################################
 #
+# Takes two times, time1 and time2 and finds the middle point
+#
+###########################################################################
+sub getMiddleTime {
+    my ($self, $time1, $time2) = @_;
+
+      my $query = $self->{_db}->prepare(<<SQL);
+         SELECT '$time1' + INTERVAL (TIME_TO_SEC(TIMEDIFF('$time2', '$time1')) / 2) SECOND; 
+SQL
+    $query->execute;
+
+return scalar $query->fetchrow_array();
+}
+
+###########################################################################
+#
 # Adds the provided interval to the provided time
 #