/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 vote192 views2 answers
Quotation marks n string
Python
3 votes201 views3 answers
Convert all columns to float pandas
Python
9 votes198 views4 answers
Multiple lines input python
Python
0 vote202 views2 answers
Detect Word Then Send Message (discord.py)
Python
3 votes207 views3 answers
How to insert image in python
Python
0 vote174 views1 answer
Jinja flask
Python Flask
5 votes211 views2 answers
Allauth django
Python
14 votes205 views3 answers
Change key of dictionary python
Python
0 vote195 views1 answer
Set up splinter
Python
2 votes160 views2 answers
How to play audio in python
Python