Angular.js function to calculate age

Question

Good evening, everyone.

In my comic book, I store customers' date of birth.

I have a list that presents:

name | Cpf | age?

How could I take the data stored in the bd and using Angular.js or php calculate the current age and fill in my list?

In the case, the data are presented in the list are thus:

{{data.name}} - {data.Cpf}} - age????

Although I knew very little about Angular.js, I accepted the challenge of studying and modifying some systems I used to do with Jquery. So far I’m enjoying it.

Answer 1

You can implement a function:

• Controller

$scope.calcularIdade = function calcularIdade(nascimento) {
    // Obtém a idade em milissegundos
    var idadeDifMs = Date.now() - nascimento.getTime();

    // Converte os milissegundos em data e subtrai da era linux
    var idadeData = new Date(idadeDifMs);
    var idade = idadeData.getUTCFullYear() - 1970;

    return idade;
}

• HTML

  {{ calcularIdade(data.nascimento) }}
  

Note that this code has precision problems. The margin of error may be a few hours in a few years, or during daylight saving time. It is recommended to use a library to do this reliably.

Answer 2

Solved, using a direct calculation in the query. Therefore, I didn’t even need to create any Javascript function... it was fast and practical!

SELECT 
  DATE_FORMAT(NOW(),'%Y') - 
  DATE_FORMAT(data_nascimento,'%Y') -
  (DATE_FORMAT(NOW(),'00-%m-%d') < DATE_FORMAT(data_nascimento,'00-%m-%'))
AS idade;

Taken from http://www.profissionaisdaweb.com.br/calculando-a-idade-diretamento-na-query-9.jsp