/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

5 votes168 views2 answers
Functions
SQL
3 votes136 views2 answers
Truncate table
SQL
4 votes141 views5 answers
Primary key
SQL
0 vote129 views1 answer
FIND most frequent word in sql server
SQL
1 vote125 views1 answer
Rows to comma separated values in mssql
SQL
4 votes124 views2 answers
Sql server date now
SQL
3 votes168 views1 answer
Oracle apex warn on unsaved changes
SQL
13 votes153 views2 answers
Sqlite rename table
SQL
0 vote138 views1 answer
Mysql master slave setup with keepalived
SQL
1 vote150 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL