Obtain age based on date in bbdd

0

Dear, I want to save a date of birth from form with jsp, then save it in bbdd mysql and then get it from the bbdd and calculate the age. Any idea how to achieve it? Greetings.

<form action="cPaciente" method="post">
<label style="color:red"><%=msj %></label>
<table width="35%">
 <tr >
  <td><label for="rut">Rut:  </label></td>
  <td><input type="text" name="ingresoRUT" title="Rut sin guion"         pattern="[0-9]{1,15}" value="<%=Rut %>" required></td>
</tr>
<tr>
  <td width="13%"><label for="nombre">Nombre: </label></td>
  <td width="87%"><input type="text" name="ingresoNombre"></td>
</tr>
 <tr>
  <td><label for="apellido">Apellido:  </label></td>
  <td><input type="text" name="ingresoApellido"></td>
 </tr>
 <tr>
 <!-- Aqui se ingresa la fecha de nacimiento -->
  <td><label for="edad">Fecha Nacimiento:  </label></td>
  <td><input type="text" name="ingresoNacimiento"></td>
</tr>
</table>
</form>
    
asked by ACapurro 13.09.2017 в 23:22
source

1 answer

0

Like this: SELECT TIMESTAMPDIFF(YEAR,'1985-09-19',CURDATE()) AS edad

    
answered by 14.09.2017 в 01:23