/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 vote136 views1 answer
How to read xlsx file from one directory above python
Python
25 votes101 views7 answers
Remove space from start and end of string in python
Python
0 vote141 views1 answer
Python min length list of strings
Python
1 vote154 views1 answer
Qslider pyqt
Python
0 vote149 views1 answer
Pytorch squeeze
Python
6 votes171 views1 answer
Pandas filter string contain
Python
0 vote141 views1 answer
Access nested set with array params python
Python
0 vote156 views1 answer
What does json.loads do
Python
2 votes129 views1 answer
Add list to end of list python
Python
1 vote154 views1 answer
Webhook discord files
Python