From: Dan Nelson Date: May 13 2011 2:46pm Subject: Re: operation with dates List-Archive: http://lists.mysql.com/mysql/224999 Message-Id: <20110513144644.GB7043@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit 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 dnelson@stripped