/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 vote207 views2 answers
Sql query for getting details by id
SQL
0 vote222 views1 answer
How to locate pg_hba.conf file
SQL
1 vote174 views1 answer
Foreign key in oracle sql developer
SQL
0 vote216 views1 answer
Différence entre deux dates sql oracle
SQL
1 vote230 views1 answer
Mariadb get column names from table
SQL
7 votes204 views3 answers
Sql get last inserted row
SQL
0 vote220 views1 answer
How to check database engine in mysql
SQL
51 votes329 views6 answers
Opera gx
SQL
0 vote211 views1 answer
How to set sql_mode for a query in CI model
SQL
2 votes198 views1 answer
Sql alchemy or
SQL