/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 vote144 views1 answer
Int to alphabet letter python
Python
1 vote152 views1 answer
Python dividing strings by amount of letters
Python
0 vote163 views1 answer
Softmax function python
Python
57 votes164 views6 answers
Python environment
Python
60 votes156 views6 answers
Python remove letters from string
Python
12 votes152 views6 answers
How to merge two dictionaries in python
Python
1 vote157 views1 answer
Python test if list of dicts has key
Python
0 vote186 views1 answer
Query first 5 element in django
Python Django
0 vote194 views2 answers
Numpy softmax
Python
2 votes151 views1 answer
Pygityb
Python