/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

1 vote116 views2 answers
Copy database mysql
SQL
1 vote132 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote121 views1 answer
Sql query for login with email or username
SQL
3 votes111 views1 answer
Locate sql server
SQL
0 vote110 views1 answer
Function sum(text) does not exist postgres
SQL
6 votes109 views3 answers
Mysql create database utf8
SQL
1 vote97 views1 answer
Jooq convert using gbk
SQL
1 vote118 views3 answers
Nth highest salary
SQL
1 vote119 views1 answer
Postgresql delete cascade
SQL
5 votes104 views1 answer
Sysdate in oracle sql
SQL