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
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