/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

32 votes183 views3 answers
Python create new folder in path that don't exist
Python
0 vote173 views1 answer
How to load multiple list of dictionary values which is stored in python file and load into another python file in python over loop
Python
0 vote229 views1 answer
Python multi-line statement
Python
0 vote188 views1 answer
Tkinter filedialog get directory path
Python
3 votes179 views1 answer
How to add text in python turtle
Python
4 votes226 views1 answer
Sort dict by value
Python
0 vote135 views1 answer
Python word encode asci
Python
0 vote186 views1 answer
Python interpreter pip
Python
0 vote186 views1 answer
Import messages
Python
0 vote179 views1 answer
Pandas Get Column Names With NaN
Python