my $query = "SELECT timestampColumn FROM mytable LIMIT 1"; my $sth = $dbh->prepare($query); $sth->execute(); while (my $row = $sth->fetchrow_arrayref()) { my $TS = $row->[0]; print "$TS ", $TS + 1, " ", $TS + 10, "\n"; } __END__ 20030524183051 20030524183052 20030524183061