Use the DATE_ADD( ) or DATE_SUB() function with INTERVAL as explained here: https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-add

-- Peter.

On Wed, May 16, 2018 at 4:07 PM, Dev C <chauhan.devsur@gmail.com> wrote:
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 ?

_______________________________________________
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