/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 vote278 views1 answer
Formatting code with SQL Developer
SQL
0 vote257 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL
0 vote282 views1 answer
Postgres create extension if not exists
SQL
1 vote273 views1 answer
Mysql count multiple columns in one query
SQL
2 votes287 views2 answers
Enable foreign key checks postgres
SQL
0 vote308 views1 answer
Mysql faster delete
SQL
-2 votes283 views4 answers
How to get max salary in each department in sql
SQL
1 vote268 views1 answer
Search for tables with name postgresql
SQL
1 vote293 views1 answer
Mysql return if it contains
SQL
6 votes297 views2 answers
Mysqldump password in file
SQL