만나이 계산식

MySql

// 만나이 계산
select (YEAR(NOW())- YEAR('19800921'))- (date_format('19800921','%m%d') > DATE_FORMAT(NOW(), '%m%d')) age

javascript

// 만나이 계산
function getAge(brth){
    var now = new Date();
    var dd = String(now.getDate()).padStart(2, '0');
    var mm = String(now.getMonth() + 1).padStart(2, '0');
    var yyyy = now.getFullYear();
    var nowYMD = yyyy + '-' + mm + '-' + dd + 'T00:00:00.000Z';
    var today = new Date(nowYMD);
    var birthday = new Date(brth + 'T00:00:00.000Z');
    var age = today.getFullYear() - birthday.getFullYear();

    if(parseInt(birthday.getDate()) <= parseInt(today.getDate())){
      age -= 1;
    }

    return age;
}