/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 vote108 views1 answer
SqlFunction does not exist
SQL
0 vote113 views1 answer
Get the Db column names from a SqlDataReader
SQL
0 vote112 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote107 views1 answer
How to check xampp mysql password
SQL
1 vote109 views1 answer
Drop function
SQL
0 vote105 views7 answers
10 random questions use python and SQL
SQL
0 vote109 views1 answer
Pl sql disable trigger
SQL
0 vote118 views1 answer
Sql server rtrim everything after character
SQL
0 vote96 views1 answer
Concat column value of same user in mysql
SQL
1 vote117 views1 answer
Oracle compile schema
SQL