/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 vote198 views1 answer
Asp.net core sql server stored procedure
SQL
1 vote211 views1 answer
Mysql add fields
SQL
1 vote390 views1 answer
Postgres convert text to number
SQL
10 votes206 views2 answers
Oracle alter sequence nextval
SQL
9 votes216 views1 answer
Alter table column change data type to text mysql
SQL
3 votes198 views1 answer
Sql is not like
SQL
0 vote221 views1 answer
Insert value in identity
SQL
0 vote193 views1 answer
Sql count null values in all columns
SQL
10 votes189 views2 answers
Tsql merge example
SQL
0 vote219 views2 answers
Call to undefined function mysql_query()
SQL