/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 vote162 views1 answer
How to check database engine in mysql
SQL
0 vote170 views1 answer
Insert output identity
SQL
0 vote128 views1 answer
Oracle tablespace autoextend
SQL
28 votes136 views4 answers
Show tables mysql
SQL
0 vote147 views2 answers
Sql query in dax power bi
SQL
1 vote139 views1 answer
Access the postgres psql
SQL
6 votes132 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote141 views1 answer
Enable full text search mysql
SQL
3 votes137 views4 answers
Order by desc postgres
SQL
0 vote126 views1 answer
Oracle list chain steps
SQL