/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 vote136 views1 answer
Sql right characters
SQL
0 vote164 views1 answer
Sql server phone constraint
SQL
0 vote141 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote149 views1 answer
Mysql date time string format python
SQL
32 votes159 views6 answers
How to change column name in sql
SQL
2 votes197 views1 answer
Oracle trace session
SQL
0 vote166 views1 answer
Mysql aspas simples
SQL
0 vote138 views1 answer
Stuff in sql server
SQL
10 votes144 views5 answers
Create table mysql query
SQL
2 votes191 views1 answer
Sql compare strings
SQL