/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 vote207 views2 answers
How covert into int in maria db
SQL
0 vote218 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote178 views1 answer
Selects all the columns from the sailors table
SQL
0 vote248 views1 answer
Sql alternative to max statement
SQL
10 votes185 views1 answer
Oracle dependency
SQL
3 votes195 views1 answer
Sql is not like
SQL
0 vote194 views1 answer
Database xml sql
SQL
1 vote151 views1 answer
Strict in postgres SQL
SQL
0 vote203 views1 answer
Mysql where don't have string
SQL
1 vote195 views1 answer
Tsql find foreign key references
SQL