/SQL/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 vote338 views1 answer
Where date in datetime mysql
SQL
0 vote284 views1 answer
Kannst du deine finger trainieren
SQL
0 vote302 views1 answer
Count column of tables psql
SQL
14 votes387 views6 answers
Finding duplicate rows mysql
SQL
0 vote329 views1 answer
Add multiple field in table sql
SQL
0 vote325 views1 answer
Minus equivalent in my sql
SQL
7 votes368 views1 answer
Show line number in sql server
SQL
0 vote332 views1 answer
How to fetch unique records from two tables
SQL
0 vote339 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote273 views1 answer
Ms sql print more than 1 variable
SQL