/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 vote234 views1 answer
Swap two columns python
Python
0 vote246 views3 answers
Python thread exception
Python
0 vote242 views1 answer
Unique mark boolean django model field
Python
0 vote282 views1 answer
Disable console messages in Flask server
Python Flask
0 vote277 views1 answer
Find record in mongodb with mongodb object id python
Python
2 votes243 views1 answer
How to add headings to data in pandas
Python
4 votes249 views2 answers
How to plot two columns graphs in python
Python
3 votes247 views2 answers
Python list multiplication
Python
4 votes240 views1 answer
Round python with list
Python
0 vote222 views1 answer
Def get_label(Dir): for nextdir in os.listdir(Dir): if not nextdir.startswith('.'): if nextdir in ['NORMAL']: label = 0 elif nextdir in ['PNEUMONIA']: label = 1 else: label = 2 return nextdir, label
Python