xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table
xxxxxxxxxx
select year(curdate())-year(dob) - (right(curdate(),5) < right(dob,5)) as age from your_table