Comment 1 for bug 972447

Revision history for this message
Padraig O'Sullivan (posulliv) wrote :

The workaround we have been doing at the moment is to use the now() function:

test=> select * from t1 where a_date > now() - interval 1 day;
 id | a_date
----+--------
(0 rows)

test=>

As part of resolving this bug, it would be nice to know which functions are not MySQL compatible if possible