/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

19 votes341 views5 answers
Display table in sql
SQL
0 vote317 views1 answer
Sql where part of string match
SQL
13 votes301 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote301 views1 answer
Mysql two joins
SQL
3 votes306 views2 answers
Brew restart mysql
SQL
2 votes310 views1 answer
Oracle apex list connected users
SQL
1 vote324 views1 answer
Sqlite update from another table
SQL
3 votes318 views3 answers
Order by postgres
SQL
0 vote350 views1 answer
Drop a view in sqlite
SQL
0 vote341 views1 answer
Mysql grant all on all databases
SQL