/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 vote330 views1 answer
Store query result in variable sql
SQL
1 vote354 views4 answers
Between vs in sql
SQL
7 votes383 views1 answer
Sql disable safe mode
SQL
0 vote379 views1 answer
Suhaib
SQL
3 votes450 views4 answers
Sql interview questions
SQL
0 vote350 views1 answer
List mysql tables and views
SQL
3 votes347 views2 answers
Having in mysql
SQL
0 vote364 views2 answers
PostgreSQL having
SQL
0 vote400 views1 answer
T-sql delete view if exists
SQL
16 votes359 views3 answers
Delete row psql
SQL