/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 vote170 views1 answer
Python logger printing multiple times
Python
0 vote180 views1 answer
Edit models in django admin
Python Django
1 vote144 views1 answer
Python display text in label on new line
Python
-1 vote168 views1 answer
Python scatter size
Python
0 vote150 views1 answer
Region error when use service account json file dataproc
Python
0 vote148 views1 answer
Floating point python
Python
3 votes144 views1 answer
How to set datetime format in python
Python
3 votes108 views1 answer
Null coalescing assignment operators python
Python
0 vote143 views1 answer
Python format new
Python
6 votes192 views2 answers
How to check if django is installed( in python shell)
Python Django