/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

19 votes201 views2 answers
How to avoid deprecation warning in python
Python
0 vote192 views1 answer
Ord python3
Python
3 votes177 views4 answers
How to convert comma separated string to list in python
Python
1 vote178 views1 answer
Pandas percent change
Python
0 vote217 views1 answer
Add image pptx python
Python
0 vote220 views1 answer
Get category discord.py
Python
0 vote178 views1 answer
My_list = ['a','b'] my_list.append('c') print(my_list)
Python
0 vote217 views1 answer
Django how to create superuser if does not exists on migration
Python Django
2 votes237 views1 answer
Django load model by name
Python Django
8 votes257 views5 answers
Python print statements
Python