/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

1 vote231 views1 answer
Ubuntu access database from terminal
SQL
0 vote208 views2 answers
Compound operator in sql
SQL
7 votes213 views1 answer
Return insert results in POSTGRESQL
SQL
8 votes275 views1 answer
Oracle search code in packages
SQL
6 votes229 views5 answers
Oracle list tablespaces
SQL
0 vote195 views1 answer
Oracle create table auto generated primary key
SQL
-1 vote186 views3 answers
Check table exist postgresql
SQL
1 vote222 views2 answers
Create table if not exist
SQL
3 votes201 views1 answer
Sql print all names that start with a given letter
SQL
0 vote147 views1 answer
Mssql view column data type
SQL