operation with dates

[Rocio Gomez Escribano]

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

 <mailto:r.sanc...@ingenia-soluciones.com> r.go...@ingenia-soluciones.com

 

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