/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 vote190 views1 answer
Formatting code with SQL Developer
SQL
1 vote196 views1 answer
Oracle grant on all tables in schema
SQL
0 vote190 views1 answer
Events not working db
SQL
0 vote205 views4 answers
Mysql replace regex
SQL
0 vote276 views1 answer
DATEDIFF minute postgres
SQL
6 votes195 views5 answers
Sql add months to date
SQL
1 vote186 views1 answer
Mysql count words
SQL
1 vote230 views2 answers
Copy table in sql
SQL
0 vote211 views1 answer
How to map sql column to custom names
SQL
6 votes288 views2 answers
Non relational database
SQL