/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

7 votes145 views3 answers
Python print exception type and message
Python
1 vote142 views1 answer
Program to segregate positive and negative numbers in same list
Python
0 vote137 views1 answer
How to join basename and directory in python os
Python
25 votes142 views6 answers
Fibonacci
Python
1 vote136 views1 answer
Pandas merge dataframes from a list
Python
0 vote210 views1 answer
Create new columns pandas from another column
Python
10 votes199 views1 answer
Django new static files directory
Python Django
2 votes148 views3 answers
Making a virtual environment python
Python
0 vote141 views2 answers
1007 solution python
Python
1 vote146 views2 answers
Why mentioning user agent in request library
Python