/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 vote267 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
1 vote345 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote322 views1 answer
Sql select rows with different values in one column
SQL
3 votes331 views3 answers
Start postgresql ubuntu
SQL
0 vote349 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
13 votes335 views2 answers
Get tables in database sql
SQL
1 vote330 views1 answer
Sql server cast date dd/mm/yyyy
SQL
0 vote335 views1 answer
Returning with sqlalchemy
SQL
1 vote325 views1 answer
Sample clause in sql
SQL
8 votes283 views1 answer
Similarities between ddl and dml
SQL