/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 vote233 views1 answer
Flask socketio usage
Python Flask
0 vote289 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python Django
0 vote236 views2 answers
Some problem occurred shows payubiz
Python
4 votes247 views2 answers
Loginrequiredmixin django
Python Django
1 vote199 views1 answer
Key down python
Python
0 vote221 views1 answer
Networkx max degree node
Python
-1 vote240 views2 answers
Np.apply_along_axis third dimension python
Python
2 votes237 views1 answer
Isolate row based on index pandas
Python
9 votes246 views1 answer
Bee movie script
Python
60 votes229 views6 answers
Translate french to english
Python