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 < r.go...@ingenia-soluciones.com> wrote: > Hello! I’m trying to subtract two dates in my consult, but I don’t get it, > I did: > > > > > > > > mysql> select userID from user where (userPaymentDate - now()) < 365 ; > > > > > > It didn’t work. Do you know how to do it? Thank you so much! > > > > Regards > > > > *RocÃo Gómez Escribano* > > r.go...@ingenia-soluciones.com <r.sanc...@ingenia-soluciones.com> > > > > [image: Descripción: cid:image002.jpg@01CB8CB6.ADEBA830] > > PolÃgono Campollano C/F, nº21T > > 02007 Albacete (España) > > Tlf:967-504-513 Fax: 967-504-513 > > www.ingenia-soluciones.com > > >