/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 vote162 views1 answer
Default stride value in keras
Python
3 votes150 views1 answer
Accessing items of tuple in python
Python
3 votes112 views1 answer
Time decorator python
Python
1 vote164 views1 answer
Aws lambda Unable to import module 'lambda_function': No module named 'requests'
Python
0 vote197 views2 answers
How to get value from txtbox in flask
Python Flask
0 vote192 views1 answer
Use in in django while preserving order
Python Django
0 vote187 views1 answer
Ord python3
Python
0 vote165 views1 answer
Flask template split string
Python
1 vote156 views2 answers
Check if user has manage messages discord.py
Python
17 votes193 views4 answers
How to install python 3.6 ubuntu
Python