http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13409 --- Comment #3 from Jonathan Druart <jonathan.druart@biblibre.com> --- Comment on attachment 34177 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=34177 Bug 13409 - Add ability to purge old special holidays using cleanup_database.pl Review of attachment 34177: --> (http://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=13409&attachment=34177) ----------------------------------------------------------------- ::: misc/cronjobs/cleanup_database.pl @@ +340,5 @@
+sub PurgeHolidays { + $sth = $dbh->prepare( + q{ + DELETE FROM special_holidays + WHERE DATE( CONCAT( year, '-', month, '-', day ) ) < DATE_SUB( CURDATE(), INTERVAL ? DAY )
It would be good to have a DB agnostic way to day that. For instance "DATE_SUB( CURDATE(), INTERVAL ? DAY )" could be done in Perl, don't you think? -- You are receiving this mail because: You are watching all bug changes.