/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 vote175 views1 answer
How to use query_params in get_object djangorestframework
Python
2 votes171 views1 answer
Pandas convert all string columns to lowercase
Python
3 votes169 views1 answer
Python 3.9 features
Python
0 vote171 views1 answer
Matplotlib remove ticks and lines
Python
1 vote299 views1 answer
Create django group
Python Django
0 vote166 views1 answer
Django nested inlines
Python
0 vote192 views1 answer
Python function guts
Python
1 vote194 views6 answers
Python tuple
Python
1 vote171 views1 answer
Flower not implemented error
Python
0 vote202 views1 answer
Area of a right angle triangle in python
Python