/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 vote253 views1 answer
Python set remove multiple elements
Python
0 vote304 views1 answer
Random module randint
Python
0 vote270 views1 answer
Pass query params django template
Python Django
0 vote327 views1 answer
Arabic text recognition from pdf using python
Python
0 vote247 views1 answer
How to find all the installed packages in python
Python
0 vote282 views1 answer
Filter dict by list of keys python
Python
0 vote261 views2 answers
Np array to tuple
Python
2 votes250 views1 answer
Generate a list of random non repeated numbers python
Python
0 vote280 views1 answer
H2o dataframe columns drop
Python
25 votes279 views3 answers
Numpy merge arrays
Python