/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 vote149 views1 answer
Numpy randomly swap lines
Python
0 vote145 views1 answer
Scikit learn library in python
Python
0 vote137 views1 answer
Python move all txt files
Python
70 votes140 views6 answers
Get list of files in directory python
Python
9 votes135 views2 answers
Discord.py unban command
Python
0 vote125 views1 answer
Python polyfit with errors
Python
0 vote123 views1 answer
Installing intel-numpy
Python
0 vote132 views1 answer
Python check mognodb size
Python
1 vote129 views1 answer
How to separate x and y from mouse position python
Python
0 vote132 views7 answers
Convert c to python online
Python