From fffd077a680acba1f4e54b7464850d8a2dc6cfc4 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 21 Oct 2015 14:31:08 +0100 Subject: [PATCH] Bug 13409: Remove MySQLism - Replace DATE with CAST AS DATE Signed-off-by: Jonathan Druart --- misc/cronjobs/cleanup_database.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/misc/cronjobs/cleanup_database.pl b/misc/cronjobs/cleanup_database.pl index cb56d5a..55224b2 100755 --- a/misc/cronjobs/cleanup_database.pl +++ b/misc/cronjobs/cleanup_database.pl @@ -399,7 +399,7 @@ sub PurgeHolidays { $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; -- 2.1.0