/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

0 vote279 views1 answer
Getting multiple of 5 python
Python
0 vote274 views1 answer
How to make a distance function in python
Python
1 vote346 views1 answer
Url in form action django
Python Django
0 vote285 views1 answer
How to open cmd and run code using python
Python
8 votes271 views2 answers
Selenium upload file python
Python
0 vote300 views1 answer
Django refresh form db
Python
0 vote244 views1 answer
Most valuable features in pandas model
Python
0 vote285 views1 answer
Swap 2 no in one line python
Python
3 votes354 views2 answers
Dict get list of values
Python
3 votes315 views3 answers
Pip install wikipedia
Python