/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 vote312 views1 answer
Sql select inside select sub query
SQL
0 vote293 views1 answer
Postgresql import data from csv
SQL
0 vote326 views1 answer
Alter check command
SQL
3 votes305 views2 answers
Sqlite show table definition
SQL
6 votes338 views2 answers
Difference between join vs union
SQL
0 vote306 views1 answer
Sql database connectivity
SQL
1 vote334 views1 answer
Customer using hdfc bank sql query
SQL
0 vote320 views1 answer
Postgresql find missing id
SQL
0 vote318 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote334 views1 answer
Oracle enable job
SQL