Get age of user

# Get user age with SQL.md

run.sql

-- Not enough precise /!\
DATEDIFF(CURRENT_DATE, `users`.`birthday`)/365 AS age

-- Working fine
DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), `users`.`birthday`)), "%Y")+0 AS age

create table users(
  id int primary key,
  username text,
  birthday DATE
);

insert into users 
  values
    (1,'Taniya','1994-12-01'),
    (2,'Bernard','1995-06-01'),
    (3,'JL','1996-10-01'),
    (4,'Seb','1997-09-01'),
    (5,'Lucie','1998-07-01'),
    (6,'Joyce','1999-08-01'),
    (7,'Chloe','2000-01-01'),
    (8,'Nathan','2001-03-01')
;

select  
  DATEDIFF(CURRENT_DATE, `users`.`birthday`)/365 AS age1,
  DATE_FORMAT(FROM_DAYS(DATEDIFF(NOW(), `users`.`birthday`)), "%Y")+0 AS  age2
  from  users;

• https://onecompiler.com/mysql/42gykzgu5