/Python/How to calculate the age from date of birth in python

How to calculate the age from date of birth in python

Python calculate age from date of birth

from datetime import date

def calculate_age(born):
    today = date.today()
    return today.year - born.year - ((today.month, today.day) < (born.month, born.day))

Source: stackoverflow.com

How to find current age from date of birth in python

today_date = datetime.datetime.now()
dob = datetime.datetime(1982, 5, 20)
print(today_date - dob)

How to calculate the age from date of birth in python

SELECT DATEDIFF (
	year, DOB, getdate()) + CASE 
      WHEN (DATEADD(year,DATEDIFF(year, DOB, getdate()) , DOB) > getdate())
      THEN - 1 
      ELSE 0
END
)

Source: stackoverflow.com

How to calculate the age from date of birth in python

SELECT CASE WHEN dateadd(year, datediff (year, DOB, getdate()), DOB) > getdate()
            THEN datediff(year, DOB, getdate()) - 1
            ELSE datediff(year, DOB, getdate())
       END as Age
FROM <table>

Source: stackoverflow.com

Similar codes

1 vote268 views1 answer
Convert rgb to a single value
Python
0 vote299 views1 answer
Buscar valor aleatorio de una lista python
Python
3 votes283 views1 answer
Lambda with two columns pandas
Python
9 votes293 views1 answer
Override python print for class
Python
9 votes285 views6 answers
Activate virtual environment python windows 10
Python
1 vote278 views1 answer
ImportError: dynamic module does not define module export function
Python
1 vote307 views1 answer
Extract images from mp4 python
Python
3 votes274 views3 answers
Python check internet connection
Python
-2 votes275 views1 answer
Play sound directly with pytts
Python
1 vote301 views1 answer
Python ndarray string array into int
Python