/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

2 votes298 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
1 vote284 views2 answers
Change table name phpmyadmin
SQL
0 vote312 views1 answer
Oracle NLS_CHARACTERSET
SQL
1 vote298 views1 answer
Create another table from existing table sql oracle
SQL
12 votes315 views1 answer
Run mysql instance in docker
SQL
0 vote296 views1 answer
Convert excel into sqllite db using python
SQL
2 votes266 views1 answer
Mysql sysdate
SQL
1 vote277 views1 answer
Postgres count string length
SQL
0 vote309 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote296 views5 answers
Select concat alter table mysql
SQL