In the last episode (May 12), Halßsz Sßndor said: > >>>> 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....
Datediff isn't portable, either :) -- Dan Nelson dnel...@allantgroup.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org