/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 vote206 views1 answer
Def plot_null_matrix(df, figsize=(18,15)): # initiate the figure plt.figure(figsize=figsize) # create a boolean dataframe based on whether values are
Python
0 vote217 views1 answer
Discard method in python
Python
0 vote266 views1 answer
Django dump previous migrations
Python Django
147 votes237 views5 answers
Python check if folder exists
Python
0 vote202 views1 answer
Python functools
Python
0 vote223 views1 answer
Find Files With a Certain Extension in the Directory and Its Subdirectories in Python
Python
6 votes236 views4 answers
Extract numbers from string python
Python
2 votes219 views1 answer
Python subprocess with environment variables
Python
2 votes221 views3 answers
Python poetry
Python
1 vote242 views2 answers
Why use python
Python