/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 vote363 views5 answers
Delete csr python
Python
0 vote357 views1 answer
Django phone number
Python
0 vote341 views1 answer
Url settings
Python
1 vote372 views1 answer
User defined functions python
Python
0 vote321 views1 answer
Turtle screen
Python
0 vote424 views2 answers
Flask lazy response style with `make_response`
Python Flask
10 votes392 views5 answers
Ordered dictionary python
Python
2 votes347 views1 answer
Python list of all tkinter events
Python
0 vote341 views1 answer
Keras train_on_batch
Python
0 vote328 views1 answer
Convert the sklearn.dataset cancer to a DataFrame.
Python