/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 vote114 views1 answer
Oracle sql winter time change
SQL
1 vote121 views2 answers
Mysql trim spaces
SQL
0 vote128 views1 answer
TSQL Code Snippet For Optimized Sales Query
SQL
2 votes118 views3 answers
Replace null in sql
SQL
0 vote110 views2 answers
Cambiar nombre tabla mysql
SQL
1 vote119 views1 answer
Postgresql delete cascade
SQL
0 vote106 views1 answer
Oracle list index on table
SQL
1 vote123 views1 answer
Sql view where tables have same column name combine results
SQL
-1 vote136 views4 answers
Full outer join in sql
SQL
0 vote127 views1 answer
Oracle concat datetime
SQL