/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 votes243 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote205 views1 answer
Update having mysql
SQL
0 vote190 views2 answers
Update information in a mysql column
SQL
17 votes212 views3 answers
How to change a collumn name in sql
SQL
2 votes229 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote187 views1 answer
How to execute stored output to csv files
SQL
8 votes216 views1 answer
Mysql limit rows
SQL
5 votes196 views1 answer
Mysql change primary key
SQL
0 vote205 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote214 views1 answer
Postgresql regular expression special characters
SQL