/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 vote130 views1 answer
Python resample and interpolate
Python
0 vote148 views1 answer
How to append panda columns using loop
Python
1 vote141 views1 answer
Change color of butto in thkinter
Python
0 vote127 views1 answer
Discord bot response to private message python
Python
0 vote125 views1 answer
Python list for all months including leap years
Python
0 vote131 views1 answer
Numpy linspace of dates
Python
0 vote159 views1 answer
Prefetched_related django rest framework
Python Django
0 vote96 views1 answer
Pyttsx3 install
Python
21 votes128 views2 answers
Convert column to datetime format python
Python
0 vote132 views1 answer
[Solved] TypeError: 'NoneType' object is not subscriptable
Python