/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 vote333 views3 answers
Move window with overrideredirect
Python
0 vote356 views1 answer
Python dict update
Python
0 vote344 views1 answer
Tqdm pandas apply
Python
1 vote330 views1 answer
Python open new chrome tab
Python
22 votes317 views10 answers
Cat
Python
0 vote338 views1 answer
Assert integer python
Python
1 vote312 views1 answer
How do you find the missing number in a given integer array of 1 to 100?
Python
0 vote344 views1 answer
Adding new fields in ModelAdmin with fieldsets to edit user, and add_fieldsets whan creating a new user
Python
1 vote333 views1 answer
Distribution plot with curve python
Python
15 votes352 views2 answers
!.gitignore
Python