While calculating the difference in two dates we need to just keep track of two conditions that will do. If the current date is less than that of the birth date, then that month is not counted, and for subtracting dates we add number of month days to the current date so as to get the difference in ... Use the birthday calculator to find out how many hours, days, months and years you've been alive for and what day you were born on. Simply enter your date of birth into the calculator and click the 'calculate' button. We also have a Chronological Age Calculator available. Famous birthdays for 12 January

Re: calculating age from Date of Birth field Dec 13, 2003 01:37 AM | ageel | LINK hi it would be simpler for you to calculate age in your database server like SELECT DATEDIFF(year, yourbirthdayfield, GETDATE()) AS Age FROM YourTable this will return the a field in your query that has the age. How to calculate age in Year,Month and Days from date of birth in MySql. i used an existing query to get the result,like select TIMESTAMPDIFF( YEAR, dojDate,now()) as years , TIMESTAMPDIFF( MONTH, dojDate,now()) % 12 as months , FLOOR( TIMESTAMPDIFF( DAY, dojDate,now()) % 30. 4375) as days