Re: operation with dates

[(Hal]

>>>> 2011/05/12 13:06 -0500, Dan Nelson >>>>
In the last episode (May 12), Rocio Gomez Escribano said:
> I found it, 
> 
> mysql> select userID from user where datediff(now(), userPaymentDate)< 365;

This can be made more readable by using mysql's INTERVAL syntax. 
<<<<<<<<
And less portable....