I suggest you try to find out yourself - you could have tens of problems every day, and this list will not solve them all.

When you have this kind of problems, try to find out how MariaDB interprets what you write. In this case try:

SELECT '5/10/2018'- 28;

Cheers,

Federico

Il mercoledì 16 maggio 2018, 16:07:25 CEST, Dev C <chauhan.devsur@gmail.com> ha scritto:

Hello

If I use below query

(metrics_5.created_at)>'5/10/2018'- 28 )

it gives me some result

but if i use below query

(metrics_5.created_at)>'5/10/2018'- INTERVAL 28 DAY )

It does not give me any result, any one know why ?