/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

-2 votes188 views1 answer
Requests.exceptions.connectionerror: ('connection aborted.', remotedisconnected('remote end closed connection without response'))
Python
2 votes180 views1 answer
Dict typing python
Python
2 votes215 views1 answer
Add header to table in pandas
Python
0 vote189 views1 answer
Rename rows pandas based on condiions
Python
1 vote199 views2 answers
How to take input in python a list using map
Python
-1 vote234 views2 answers
Python dict remove duplicates where items are not the same
Python
1 vote191 views1 answer
Cprofile implementation
Python
2 votes200 views2 answers
Roots of quadratic equation in python
Python
2 votes207 views1 answer
Average within group by pandas
Python
0 vote185 views1 answer
Python post request multi argument
Python