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 resultbut 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 ?_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp