/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 vote230 views1 answer
Set open file limit mac catalina mysql
SQL
-1 vote290 views5 answers
Left join sql
SQL
0 vote237 views1 answer
Sqlite higher or equal
SQL
2 votes239 views1 answer
Oracle kill job by sid
SQL
0 vote241 views1 answer
If column value is null then in mysql
SQL
0 vote244 views2 answers
Sql count number of rows after group by
SQL
0 vote255 views2 answers
What is rownum in oracle
SQL
0 vote267 views1 answer
Psql initialization
SQL
9 votes232 views2 answers
Mysql change value
SQL
1 vote234 views1 answer
Sql server select rows by distinct column
SQL