[Koha-bugs] [Bug 10606] MySQLism in GetUpcomingDueIssues

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10606

--- Comment #11 from Jonathan Druart <jonathan.druart at biblibre.com> ---
(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.