/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 vote207 views1 answer
Structural pattern matching python
Python
2 votes196 views1 answer
Python only numbers in string
Python
1 vote190 views2 answers
Copy string python
Python
1 vote190 views1 answer
Python nCr n choose r function
Python
0 vote266 views1 answer
Linear algebra ipython notebook
Python
0 vote198 views1 answer
Size pilimage
Python
27 votes205 views4 answers
Create a dataframe from dict
Python
1 vote191 views2 answers
Python get today's date without time
Python
0 vote262 views4 answers
Python call function from string
Python
0 vote201 views1 answer
Dicttoxml python?
Python