/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 vote92 views1 answer
Django blog new post
Python
0 vote105 views1 answer
Django many to many post update method via rest
Python Django
0 vote89 views1 answer
Pandas get cvvlaue from antoiher column fom one coluikmnn value
Python
3 votes97 views3 answers
2d array python initialize
Python
43 votes98 views6 answers
Python array to string
Python
65 votes107 views4 answers
Python csv dict reader
Python
0 vote108 views1 answer
Long to_bytes python how to use it
Python
0 vote112 views1 answer
Ball python
Python
0 vote102 views1 answer
Python window icon on task bar
Python
0 vote108 views1 answer
How to create copy of all objects in list python
Python