Tizag.com Webmaster Tutorials - A collection of webmaster tutorials from HTML to PHP.

Thursday, January 6, 2011

Calculate age from DOB(Date of Birth)

SELECT EXTRACT( YEAR
FROM (
FROM_DAYS( DATEDIFF( NOW( ) ,paient_date_of_birth) ) )
) +0 AS present_age
FROM patient_list
LIMIT 0 , 30
Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)