http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802
--- Comment #16 from Jonathan Druart <[email protected]> --- (In reply to Katrin Fischer from comment #15) > Do we have a reference about CURRENT_DATE being a mysqlism? > I found it here: http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt At least, it does not work with PostgreSQL: postgres=# select CURRENT_DATE(); ERREUR: erreur de syntaxe sur ou près de « ( » LIGNE 1 : select CURRENT_DATE(); ^ postgres=# select current_date; date ------------ 2013-09-09 > Also bit worried about changing all those statements without tests. I don't have the time to provide unit tests for all modified routines. But MariaDB [koha_devstetienne]> select CURRENT_DATE(); +----------------+ | CURRENT_DATE() | +----------------+ | 2013-09-09 | +----------------+ 1 row in set (0.00 sec) MariaDB [koha_devstetienne]> SELECT CAST(now() AS date); +---------------------+ | CAST(now() AS date) | +---------------------+ | 2013-09-09 | +---------------------+ 1 row in set (0.00 sec) -- 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/
