maria-developers team mailing list archive

[Peter Laursen <peter_laursen@xxxxxxxxxx>]

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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>