Tids regninger uden moms

["Carsten Holck" <sslug@sslug>]

Hej jeg skal bruge en søgning i min MySQL database for data der ligger i et
10 min vindue for en time siden

Dette virker, men er der en smartere måde?
*****************************
..............
use Statistics::Descriptive::Discrete;
...............
my $dsn="DBI:$driver:database=$database;host=$hostname";
my $dbh = DBI->connect($dsn,$user,$password);
.......................
$timeP = localtime;
print "Now:",$timeP->strftime( "%Y-%m-%d %T"),"\n";

$timeP = $timeP - 4200;  # minus 1:10
my $starttime = $timeP->strftime( "%Y-%m-%d %T");
$timeP = $timeP +  600; # plus 0:10
my $sluttime = $timeP->strftime( "%Y-%m-%d %T");
print "fra: $starttime til: $sluttime\n";

$sth=$dbh->prepare("SELECT * from vanddata where datetime > ? and datetime <
?");
$sth->execute($starttime,$sluttime);

my $table=$sth->fetchall_arrayref;
foreach $i (@$table){
 $stats1h->add_data(@$i[3]);
 }
print "Middel:",$stats1h->mean(),"\n";
..........
********************'
Komentarer velkomne;-)

/@rsten