/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

3 votes98 views1 answer
Sql server version query
SQL
10 votes100 views1 answer
Oracle object dependencies
SQL
5 votes124 views1 answer
Oracle get ddl
SQL
2 votes93 views1 answer
Insert from table tsql
SQL
0 vote100 views1 answer
Oracle sql copy table without data
SQL
9 votes100 views1 answer
Identity insert on sql server
SQL
0 vote103 views1 answer
Best sql collation
SQL
0 vote109 views1 answer
Postgresql delete limit
SQL
0 vote118 views1 answer
On delete set default
SQL
0 vote115 views1 answer
Sql sum show 0 result
SQL