/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 vote195 views1 answer
Declare or use variable in snowflake
SQL
10 votes164 views2 answers
Forgot my mysql password mac
SQL
11 votes184 views1 answer
Oracle insert from select
SQL
0 vote190 views1 answer
Hour differeence in mysql
SQL
3 votes177 views1 answer
How to uninstall microsoft sql server
SQL
0 vote166 views1 answer
Get last updated row sql server
SQL
2 votes175 views1 answer
Sql server case sensitive search
SQL
9 votes152 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote175 views1 answer
Convert int to varchar sql
SQL
3 votes177 views1 answer
Null sql
SQL