/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 vote339 views1 answer
Python timestamp shift one day
Python
0 vote357 views3 answers
How to print a text in python
Python
2 votes333 views1 answer
Combine date and time to datetime pandas
Python
27 votes410 views4 answers
Discord.py status
Python
12 votes364 views3 answers
Setwd python
Python
0 vote400 views1 answer
Add legend to colorbar
Python
0 vote364 views1 answer
Flask development mode
Python Flask
14 votes349 views3 answers
Pyautogui down arrow
Python
0 vote372 views1 answer
Django update replace regex
Python Django
0 vote363 views1 answer
Multi-line comments Python Example
Python