/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 vote246 views1 answer
Python gaussian filter
Python
76 votes284 views6 answers
How to iterate through a list in python
Python
2 votes230 views2 answers
Generate random integer matrix python
Python
1 vote221 views1 answer
Python filter list of int and strings
Python
5 votes249 views1 answer
Shift elements in list python
Python
0 vote263 views2 answers
Python datetime to seconds
Python
0 vote236 views1 answer
Pytesseract restrict char
Python
2 votes239 views2 answers
Time difference between two datetime.time
Python
93 votes239 views4 answers
How to install python pyautogui
Python
0 vote227 views1 answer
Python generate sine wave pyaudio
Python