Free Web programing Tutorial

Calculate Age with MySQL

You can using mysql calculate age with two way using sotred procdures or with mysql query with calculate two variable date, you can using stored procedures if you alwasy using this function in your project, but if you using calculate age for one more time you can using mysql query to simple.

How to Calculate Age in MySQL with Stored Procedures

with mysql Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data. you can only using Store Procdures in Mysql 5.0 or more, with mysql stored procedures  you  can easy calculate age in mysql.

this Stored  Procedures function to calculate time difference or calculate age :

to used this procedures you can call store procedures function  :

How to Calculate Age in MySQL with query

now what i can i do with mysql query for calculate total age to simple used you can using mysl query to calculate age like this :

1# line mysql calculate year
2# line mysql calculate mounth
3# line mysql calculate days

you can using mysql calculate time difference year, mounty and days with this query.

Share on Facebook