/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 vote213 views1 answer
Applies the f function to all Row of this DataFrame
Python
0 vote188 views2 answers
Bokeh bar chart
Python
0 vote192 views1 answer
Input date args python datetime
Python
0 vote201 views1 answer
How to make images in python
Python
16 votes226 views3 answers
Self keyword in python
Python
1 vote218 views1 answer
Change index function for class python
Python
13 votes196 views4 answers
Discord.py how to give a user a role
Python
0 vote195 views1 answer
Solve linear equation with np.linalg.solve
Python
1 vote195 views1 answer
Drop every other column pandas
Python
1 vote187 views1 answer
Verificar se arquivo existe python
Python