http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10606
--- Comment #11 from Jonathan Druart <[email protected]> --- (In reply to Galen Charlton from comment #10) > The DATE() function returns a date, but it looks like DATEDIFF(DATE( > date_due ),DATE( NOW() )) works but " DATE( date_due )-DATE( NOW() )" does > not. I confirm they pass with MySQL and they don't pass with MariaDB. Using MariaDB: MariaDB [koha]> select to_days("2013-08-21 23:59:00")-to_days(NOW()); +-----------------------------------------------+ | to_days("2013-08-21 23:59:00")-to_days(NOW()) | +-----------------------------------------------+ | -6 | +-----------------------------------------------+ MariaDB [koha]> select date("2013-08-21 23:59:00")-date(NOW()); +-----------------------------------------+ | date("2013-08-21 23:59:00")-date(NOW()) | +-----------------------------------------+ | -6 | +-----------------------------------------+ Really odd... -- 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/
