/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

1 vote269 views1 answer
Split a text file into multiple paragraphs python
Python
1 vote289 views2 answers
Get env variable linux python
Python
0 vote249 views1 answer
Pandas create average per group
Python
0 vote283 views1 answer
Pandas count show one column
Python
0 vote223 views1 answer
Datetime decreasing date python
Python
0 vote340 views2 answers
Fetch api flask url redirect
Python Flask
0 vote271 views2 answers
Python concatenation
Python
0 vote274 views1 answer
Django auth user model
Python Django
1 vote247 views1 answer
UnicodeDecodeError: 'charmap' codec can't decode byte 0x9d in position 340: character maps to <undefined>
Python
2 votes290 views2 answers
Set axis plt python
Python