/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 vote131 views1 answer
Python how to change a point in a multidimensional list
Python
79 votes129 views4 answers
Write a file python
Python
5 votes129 views2 answers
How to reset username and password in django admin
Python
12 votes373 views1 answer
Time passed python
Python
0 vote153 views1 answer
Django.db.utils.ProgrammingError: can't adapt type 'dict_keys'
Python
0 vote135 views1 answer
Python von konsoleeinlesen
Python
2 votes130 views1 answer
How to create a loop in python turtle
Python
0 vote127 views1 answer
Isapha
Python
107 votes126 views6 answers
Python do while loop
Python
-1 vote117 views2 answers
Python array use numpy arange
Python