/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

35 votes320 views6 answers
Pandas merge dataframes
Python
0 vote310 views3 answers
Find next multiple of 5 python
Python
2 votes305 views1 answer
Change image resolution pillow
Python
3 votes355 views2 answers
For loop python start at 1
Python
4 votes347 views2 answers
Python join array of ints
Python
3 votes325 views3 answers
Matplotlib transparency
Python
4 votes323 views1 answer
How to increase text size tkinter
Python
0 vote311 views1 answer
Matlab find 2d index
Python
0 vote334 views1 answer
Anvil get last row of data table
Python
0 vote316 views1 answer
Jupyter notebook GET 500
Python