/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 vote345 views1 answer
Python read file to eof
Python
6 votes290 views1 answer
Display Max rows in a pandas dataframe
Python
0 vote362 views1 answer
How to change a particular text inside a list of dictionary
Python
0 vote302 views1 answer
Online convert http query to json python
Python
0 vote307 views3 answers
RegExp numéro français
Python
0 vote298 views1 answer
Django send_mail not working in testcase
Python
30 votes318 views6 answers
Pandas drop columns
Python
3 votes312 views1 answer
Isaplha in python
Python
0 vote283 views1 answer
Raspberry pi run python script on boot
Python
0 vote305 views1 answer
When training= false still dropout
Python