http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13409
--- Comment #3 from Jonathan Druart <[email protected]> --- 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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
