/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 vote298 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote222 views1 answer
18446744073709551615 mariadb left join order by
SQL
2 votes214 views1 answer
Sql create database
SQL
16 votes229 views4 answers
Ascending order mysql
SQL
2 votes165 views1 answer
Oracle current date without time
SQL
20 votes231 views3 answers
Update values in select statement sql
SQL
0 vote267 views1 answer
Postgres rename database
SQL
3 votes247 views2 answers
Check data in table mysql
SQL
6 votes237 views2 answers
Foreign key sqlite3 python
SQL
0 vote206 views1 answer
Create function syntax sql server
SQL