/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 vote320 views1 answer
Tech with tim
Python
0 vote349 views3 answers
How to take a screenshot using python
Python
1 vote303 views1 answer
Grid in pygame
Python
0 vote322 views1 answer
Find & set values in pandas Dataframe
Python
7 votes324 views2 answers
How to change values of dictionary in python
Python
0 vote321 views1 answer
Flask remove file after send_file
Python
9 votes328 views4 answers
Short if python
Python
1 vote306 views1 answer
Filter with different operator in django
Python
0 vote311 views2 answers
Python - Comment vérifier une corde contient un nombre
Python
0 vote354 views1 answer
Extract filename from path in Python
Python