/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 vote189 views1 answer
Mp.solutions.findhands not in python 3.8
Python
0 vote195 views1 answer
Python django os error
Python
0 vote163 views5 answers
Print string python
Python
0 vote176 views1 answer
Tkinter how to update optionmenu contents
Python
1 vote170 views1 answer
View whole dataset in python
Python
0 vote159 views1 answer
Copy class selenium python
Python
1 vote205 views1 answer
Matplotlib dark mode
Python
1 vote133 views3 answers
Python is float function
Python
3 votes174 views2 answers
Randomly shuffle array python
Python
9 votes174 views1 answer
Create models in django
Python