Re: [Maria-developers] [Maria-discuss] Interval in MYsql query
![](https://secure.gravatar.com/avatar/6856a1f0f722fbef5eef6f496fc6fab3.jpg?s=120&d=mm&r=g)
16 May
2018
16 May
'18
4:21 p.m.
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#functio...
-- Peter.
On Wed, May 16, 2018 at 4:07 PM, Dev C
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
2307
Age (days ago)
2307
Last active (days ago)
0 comments
1 participants
participants (1)
-
Peter Laursen