/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 votes156 views1 answer
Ceil in python3
Python
2 votes154 views2 answers
Python number and name of weekday
Python
74 votes151 views6 answers
Append dictionary python
Python
9 votes169 views1 answer
Drop the last row of a dataframe
Python
0 vote203 views1 answer
Create fixtures django
Python
-1 vote167 views2 answers
Shutil remove
Python
0 vote145 views1 answer
Bulk file name changer in python
Python
0 vote203 views1 answer
Calculate quartil python
Python
-1 vote171 views1 answer
Count true in a dataframe
Python
0 vote152 views1 answer
Networkx - remove small components from a graph
Python