/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

6 votes134 views9 answers
E
Python
68 votes117 views6 answers
Create folders in python
Python
0 vote108 views1 answer
How to join basename and directory in python os
Python
0 vote74 views1 answer
Json payload python
Python
1 vote132 views1 answer
Pandas iterrows tqdm
Python
0 vote141 views1 answer
How to return an html file in flask
Python Flask
0 vote110 views2 answers
Jama python rest api
Python
1 vote146 views1 answer
Python count variable and put the count in a column of data frame
Python
3 votes116 views1 answer
Pandas reciprocal
Python
0 vote114 views1 answer
Array search with regex python
Python