my $query = 'INSERT INTO datum (bestelldatum, expire) VALUES( NOW(), ADDDATE(NOW(), INTERVAL 1 YEAR))'; $dbh->do($query);