Re: operation with dates

[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.  It can
also be made more efficient by moving userPaymentDate out of the function,
so if you have an index on that column mysql can use it:

select userID from user where userPaymentDate > (now() - interval 1 year)

-- 
	Dan Nelson
	dnelson@stripped