/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 votes332 views1 answer
Anonymous block plsql
SQL
3 votes345 views1 answer
Oracle function return
SQL
0 vote334 views1 answer
How to use select union and loop
SQL
1 vote356 views1 answer
What is a Database?
SQL
0 vote365 views1 answer
Sql delimiter to columns
SQL
0 vote345 views1 answer
Isnull in sqlite
SQL
0 vote347 views1 answer
Database traccar
SQL
0 vote338 views1 answer
Alter owner in PostgreSQL
SQL
0 vote307 views1 answer
Como leer datos de mysql esp32
SQL
0 vote317 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL