my $last28days = time - 60*60*24*28; $sql = "SELECT * FROM TTD WHERE SecSinceEpoch > $last28days";