/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

28 votes101 views3 answers
Np.zero
Python
0 vote115 views1 answer
KeyError: 'ProfilePage'
Python
0 vote106 views1 answer
Standard noramlization
Python
0 vote97 views1 answer
Add option in python script
Python
6 votes107 views3 answers
Pandas create dataframe from multiple dictionaries
Python
4 votes104 views1 answer
Knn sklearn
Python
8 votes106 views3 answers
Python add variable to function dynamically
Python
0 vote131 views1 answer
Django update request.post
Python Django
0 vote142 views1 answer
Adding extra fields to user model django
Python Django
1 vote97 views1 answer
Python template generics
Python