/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 vote302 views1 answer
Flask buildspec.yml
Python Flask
0 vote262 views1 answer
Remove initial space python
Python
0 vote290 views2 answers
Django get superuser password
Python Django
0 vote257 views1 answer
Compress tarfile python
Python
2 votes265 views2 answers
Flask hello world get
Python Flask
0 vote257 views1 answer
Use gpu for python code in vscode
Python
0 vote233 views1 answer
Python requirments.txt
Python
5 votes245 views2 answers
Python how to put int into list
Python
1 vote259 views1 answer
Python import all words
Python
0 vote276 views1 answer
What Is Python Recursive Function in python
Python