I found it,
mysql> select userID from user where datediff(now(), userPaymentDate)< 365; Thanks Rocío Gómez Escribano [email protected] Polígono Campollano C/F, nº21T 02007 Albacete (España) Tlf:967-504-513 Fax: 967-504-513 www.ingenia-soluciones.com -----Mensaje original----- De: Andrew Moore [mailto:[email protected]] Enviado el: jueves, 12 de mayo de 2011 17:11 Para: Rocio Gomez Escribano CC: [email protected] Asunto: Re: operation with dates Rocio, there are specific date functions that you need to learn to allow you to complete this kind of query. Please check out the MySQL documentation for this. HTH Andy On Thu, May 12, 2011 at 4:05 PM, Rocio Gomez Escribano < [email protected]> wrote: > Hello! Im trying to subtract two dates in my consult, but I dont get it, > I did: > > > > > > > > mysql> select userID from user where (userPaymentDate - now()) < 365 ; > > > > > > It didnt work. Do you know how to do it? Thank you so much! > > > > Regards > > > > *Rocío Gómez Escribano* > > [email protected] <[email protected]> > > > > [image: Descripción: cid:[email protected]] > > Polígono Campollano C/F, nº21T > > 02007 Albacete (España) > > Tlf:967-504-513 Fax: 967-504-513 > > www.ingenia-soluciones.com > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[email protected]
