You can see MySQL timestamps as numbers.
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
Be aware, though, that timestamps in MySQL can't deal with time intervals smaller than one second. Depending on how fast is your server, you may have several thousand records with the same timestamp. Just to give you a hint, in my laptop, I managed to insert 100,000 records in 2.6 seconds. In my company's server, I did the same operation in 0.8 seconds. Of course, ALL those records have the same timestamp.
