$sth = $dbh->prepare(
q{
DELETE FROM special_holidays
WHERE DATE( CONCAT( year, '-', month, '-', day ) ) < ?
WHERE CAST( CONCAT( year, '-', month, '-', day ) AS DATE ) < ?
}
);
$sth->execute( $date->ymd ) or die $dbh->errstr;
-