← Back to team overview

maria-discuss team mailing list archive

Re: Interval in MYsql query


 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;

    Il mercoledì 16 maggio 2018, 16:07:25 CEST, Dev C <chauhan.devsur@xxxxxxxxx> ha scritto:  
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@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help  : https://help.launchpad.net/ListHelp