/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 vote229 views1 answer
How to group by month using sql server
SQL
0 vote224 views1 answer
Do postgresql
SQL
1 vote233 views1 answer
SQL: merging multiple row data in string
SQL
1 vote228 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
1 vote240 views1 answer
Psql import backup file for windows
SQL
0 vote245 views1 answer
Load data infile mariadb slow
SQL
0 vote221 views1 answer
Sql grant select only
SQL
1 vote223 views3 answers
Postgresql crete view
SQL
0 vote242 views3 answers
Joins and views sql
SQL
6 votes235 views3 answers
Commit in sql
SQL