/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 vote271 views1 answer
Youtube view bot python code pastebin
Python
2 votes261 views2 answers
Timestamp e datetime python
Python
1 vote285 views1 answer
Django making a custom 403 page
Python
1 vote311 views1 answer
Flask render error template
Python Flask
1 vote315 views1 answer
Lecture de fichier python
Python
0 vote264 views1 answer
Pytest suppress errors
Python
0 vote301 views1 answer
Django trigger when an instance od data is deleted from model
Python Django
1 vote335 views1 answer
Unresolved reference 'django'
Python
0 vote274 views1 answer
Rename rows pandas based on condiions
Python
34 votes281 views6 answers
Simple flask app
Python