/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 vote129 views1 answer
How many columns can be used for creating index?
SQL
0 vote135 views1 answer
Get first 3 letter of department name in sql
SQL
4 votes258 views1 answer
Oracle table statistics
SQL
0 vote129 views1 answer
Default order by in mysql
SQL
2 votes143 views1 answer
Merge firstname and lastname in sql oracle
SQL
5 votes128 views1 answer
Pl sql asynchronous procedure calls
SQL
1 vote146 views1 answer
Varchar plsql
SQL
6 votes151 views2 answers
WHERE value IS sql
SQL
1 vote124 views1 answer
Oracle check table space
SQL
0 vote178 views1 answer
Restart serial number for postgres
SQL