I can't find solution, I'm trying to take in my database date of event that are 10 days after now.

I tried :

```
SELECT * FROM XXX.Vente WHERE date > (now()+40);

```

and :

```
SELECT * FROM LeVigneau.Vente WHERE date > now()+INTERVAL 10 DAY;

```

But it doesn't work. 
Du you have an idea ? 
Thanks a lot