/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 vote366 views1 answer
Ansi sql count duplicate rows
SQL
2 votes342 views2 answers
Mysql on duplicate key ignore
SQL
1 vote357 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
-1 vote348 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
1 vote391 views1 answer
Isnull sql server
SQL
0 vote363 views4 answers
First max salary in sql
SQL
0 vote404 views1 answer
Mysql sum per week
SQL
0 vote372 views1 answer
Sql date between one week
SQL
3 votes392 views1 answer
Sql double index
SQL
1 vote368 views1 answer
Sql dcl
SQL