I have the columns mesesAtraso
and it is of type INT() , also FechaUltimoPago
of type Date() .
How can I do so that with a TIMESTAMPDIFF I give value to
mesesdeatraso
?
Performing the following query gives me the value I want to assign but I don't know how to proceed.
TIMESTAMPDIFF(MONTH, fechaUltPago, CURDATE()) AS mesesatraso from socio;